AD 95-09-13
Registered aircraft · 1,061
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:95-09-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:95-09-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:95-09-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:95-09-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.
N540CASpradlin Flying Service Inc · Petersburg, TXN540CCAndriopulos Salguero Inc · Hialeah, FLN540NEAirswiss Inc · Wilmington, DEN5417CExecutive Aircraft Management Services LLC · Pompano Beach, FLN5421FAlvey Chad R · Bargersville, INN543PMPhillips Brant · Franktown, CON5461VGoldt Robert · Simpsonville, SCN5478GOn Wings Of Eagles LLC · Valley Center, CAN548GAHyannis Air Service Inc · Hyannis, MAN5497GRichardson Farms Land Mgt Inc · Pittsfield, ILN54CRCage Presnall C · Falfurrias, TXN54JQRegistered aircraftN-number assigned (import), not yet registeredN54SADodson International Parts Inc · Rantoul, KSN54TTRedcell Air Inc · Miami, FLN54ZPSouth Aero Inc · Albuquerque, NMN5515CIsland Fliers LLC · Sheridan, WYN5529VCandlestick Aviation Services LLC · Lewes, DEN553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTN553SWHeritage Air LLC · Grove, OKN554CCAmg/Sherfick Aviation LLC · Noblesville, INN5554GGaluk Douglas P · Wisconsin Rapids, WIN555CTN555ct LLC · Largo, FLN555KKGe Flyer 1 LLC · Sheridan, WYN555WPSherry-Aire LLC · Sidney, MTN558BFMatrix Aviation LLC · Birmingham, MIN55LPAir Flight Inc · Fort Lauderdale, FLN55RLSound Harbor Aviation LLC · Wilmington, NCN55WSFour To One LLC · Decatur, ALN564RRAlpha Romeo Aviation LLC · Newark, DEN567WAJasper Aviation Inc · Jasper, ALN5680CSea Spray Aviation LLC · New Smyrna Beach, FLN5688C5688c LLC · Glendale, AZN5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEN569JMInternational Air Services Inc Trustee · Carson City, NVN569PAHerron Aviation Group LLC · Dexter, MIN56GKMatan Kai LLC · West Hollywood, CAN56RXKing Cobra Investments LLC · Rancho Cordova, CAN56TJTrue North Aviation LLC · Leclaire, IAN575JBForbes Consolidated Inc · New Smyrna Beach, FLN575RCRichland Aviation Inc · Sidney, MTN575SWHester Thomas F · Santa Barbara, CAN577KGMccloy Mark T · Tatum, NMN577RJAviation Trust Company LLC · Oklahoma City, OKN57PBHyannis Air Service Inc DBA · Hyannis, MAN57WAE2 Hangar LLC · Folsom, CAN5826CBank Of Utah Trustee · Salt Lake City, UTN588TBVlot Cole T · Wellington, NVN589STCurtis & Son Vacuum Service Inc · Liberty, TXN58AWAmplatz Left Aviation LLC · Rapid City, SDN58HBjk Aviation LLC · Morgantown, WV
Back to AD 95-09-13