AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N227TFTop Flight Aviation Inc · Corona, CAN2280RRusso John · Seaside, CAN2280TRegistered aircraftN2281GBurriss James E Jr · Piedmont, SCN2281TAvpac Insurance Services Inc · Santa Ana, CAN2284CS L G Enterprises · Shelby Township, MIN2284TKenley Clay · Crockett, TXN2285CIturriria John M · Kuna, IDN2285GRensberger Scott C · Lake Jackson, TXN2285SPlonk Daniel W · Chiefland, FLFirst renewal noticeN2287GLockwood William E · Carmel, NYN2287RTail Winds To The Island Inc · Ashland, KYN2288GSkydive Buckeye LLC · Buckeye, AZN228CPColumbia Pacific Aviation Inc · Moses Lake, WAN228HPLance Reid Enterprises LLC · Turlock, CAN228JASky Port Inc · Kalispell, MTN228JPMazel Wings LLC · Camden, DEN2290GHooker John L · Iowa Park, TXN2290SElco Avion LLC · Eagle Lake, TXN2292CKlein John T · Austin, ARN2292GNelson Erik · Exeter, NHN2293GEischen Kent A · Smoot, WYN2293JFrey Jerry P · Fallon, NVN2294CHitch Dixon S · Malta, MTN2294GHenderson Ramsey H · Pittsboro, NCN2295RDuhl James R · Roseville, MNFirst renewal noticeN2295WBraswell Jerrold W · Dillingham, AKN2296RCelias Food Corp · Miami, FLN2296TRegistered aircraftN2298GPerkins Larry L · Wildomar, CAN2298TT C Rocket LLC · Traverse City, MIN2299CMiller William C · Boise, IDN2299GLewis Frank B · Meeteetse, WYN2299RBaer Monte Wayne · Ronan, MTN2299TC And L Outfitters LLC · Everglades City, FLN229CN229c LLC · Holt, MOFirst renewal noticeN229CACivil Air Patrol · Maxwell Afb, ALN229CPCivil Air Patrol · Maxwell Afb, ALN229CSChicostate Aviation LLC · Wilmington, DEN229ESilver Creek Aviation Services · Fort Worth, TXN229LPDuke Air LLC · Romeo, MIN229WWMcgregor Daniel A · Denali Park, AKN22CRegistered aircraftN22CFGame Equipment Services LLC · Midland, TXN22CVMcginley Donald J · Port Orange, FLN22DXHawk Daniel G · Cocoa, FLN22EPRobinson Michael · Tucson, AZN22FBWilson Travis · Beaver Dam, KYN22GCSkydive Ky LLC · Cecilia, KYN22GPDunkelburg David L · Milton Freewater, OR
Back to AD 84-10-01 R1