AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N2540NStover Charles E · Osceola, INN2540VMathis Jimmie L · Port Orchard, WAN2541CBartelli Stephen J · Wasilla, AKN2542CPapa Bravo LLC · Decatur, ALN2542KSilvaire Salmon LLC · Dillingham, AKN2542UDoak Ronald E · Reno, NVN2543CCarroll Arthur G Trustee · Eagle Lake, MEN2543FRowley Harold · Greensboro, ALN2543KTracy Chris A · Carmichael, CAN2543NFunes Mauricio A · Durham, NCN2544DBouvier Ryan B · Granby, MAN2544NMaslen Halbrook · Carson City, NVN2544YChristianson Cleet M · Enumclaw, WAN2545DEvans Shane B · Carbondale, CON2545FJewell Anthony G · Reedley, CAN2545VFun Flyers LLC · Comstock, MIN2545YCalifornia Aviation Services Inc · Riverside, CAN2546DWhitfield Robert O Jr · Hurdle Mills, NCN2546FLloyd Clee E · Canby, ORN2546HWing Wendall E · Marion, MIN2546YAvquest LLC · Jonesboro, ARN2547EFour Seven Echo LLC · Lenexa, KSN2547JNguyen Tu Tuan M · Euless, TXN2547KSullivan Stephen G · Mize, MSN2547LDavis Tyler · Laurinburg, NCN2547UCostanzo Richard L · Toms River, NJN2548DIbarra Rivera Christian · Boca Raton, FLN2548KBauer Keith F · Taneytown, MDN2548UAlt Alexander B · Lockport, NYN2548YColbert Robert R · Oroville, WAN2549FAgaliotis Paul E · San Martin, CAN2549LSiemon Mark R · Belle Plaine, MNN2549YHerlihy Douglas · Denville, NJN254NYAckerman Rachael K · Sauk Rapids, MNN2550FOdom Richard · Williamson, GAN2550JBlackburn Richard L · Pendleton, ORN2550KChildress David W · Coldwater, MSN2550LWooten Craig J · Campobello, SCN2551CRobertson Tia M · Acworth, GAN2551DLast Frontier Tailwheel LLC · Anchorage, AKN2551JPeraza Jalil · Oklahoma City, OKN2552FCarolina Warbirds LLC · Patuxent River, MDN2552JRegistered aircraftN2552LFirst Flight Corp · San Diego, CAN2552VBurril Matthew C · Asheville, NCN2553BAdirondack Air LLC · Wilmington, DEN2553CSwanson Lonnie L · Delta Junction, AKN2553DJohnson Nathaniel D · Attalla, ALN2553NSandhills Veterinary Clinic P C · Arthur, NEN2553VJj&M LLC · Red Lodge, MT
Back to AD 94-05-05 R1