AD 97-01-13
Registered aircraft · 54,837
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N21YCp Aviation Inc · Santa Paula, CAN22001Fisher Robert G Jr · Hodges, SCN22003Hall David D · Des Moines, WAN22009Dundon Nick · Bozeman, MTN2200GCarey Alan W · Fallon, NVN2200XPowell George · Locust Grove, GAN22014Sun Valley Aviation Inc · Harlingen, TXN22016Kiehle Ingrid E · Anchorage, AKN22019Swindell Daniel J · Greensburg, PAN2201YInternational Air Services Inc Trustee · Carson City, NVN22025Scheck Christopher R · Troutdale, ORN22027Lyles Bobbi L · Broken Arrow, OKN22029Youth Eagles Aviation · Elk Grove, CAN2202JMartin Paul H · Willows, CAN22034Robertson David L · Ray, MIN22037Johanson Jonas P · Groveland, CAN22039Barkan James · Las Vegas, NVN2203GBartek John · Glenwood Springs, CON22049Air Carriage Inc · Chico, CAN2204CPainter Creek Lodge Inc · El Rito, NMN2204GSweet Matt · Galt, CAN2204YEagle Sky Patrol Inc · Deadwood, SDN22053Stoddard Greg E · Anchorage, AKN22060Watson Thomas G · Sunderland, MAN22069Frank Merle R Trustee · Wasilla, AKN2206CPatton Mark A · Aurora, CON2206YSanders Andrew · Livingston, MTN22070Mcmullen Christopher · Holt, MON22076Glacier Flight Training LLC · Whitefish, MTN22078Line Electric Company LLC · Lake City, FLN2207CDurden Dewitt D · Spanish Fort, ALN2207ETeton Leasing LLC · Pocatello, IDN2207GTatro Christopher A · Madras, ORN2207JCoolidge Marvin L · Newberg, ORN2208Gibson Kevin T · Orange, VAN22080Sale Reported · Las Vegas, NVSale reportedN22085Chandler Judd S · Corryton, TNN22086Jackson Allan D · Wetumpka, ALN2208GAskerli Auto LLC · Kalispell, MTN22090Aces Aviation LLC · Buffdale, UTN2209EIngersoll George P · Lakewood, CON220BRSimmonds Gary Bert · San Antonio, TXN220EAEagle Air Transport Inc · Ottawa, ILN220EPLeyva Jose Luis · New Smyrna Beach, FLN220FBCulbertson William Theodore · Helena, MTN220GDJoseph M De Lecce Trustee · Prather, CAN220HDAce Transport Service Inc · Wilmington, DEN220JAHogan Field Hangars LLC · Fairfield, OHN220MEBoyle Flying Service Inc · Boyle, MSN220NYCa Aviation 172 LLC · Santa Barbara, CA
Back to AD 97-01-13