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.
N2581YOverman Aviation LLC · Saint Louis, MON25822Duke Jimmy · Isola, MSN2582DFriesen Gary J · Mariposa, CAN2582LRichardson Michael Todd · Wilkesboro, NCN2582VThul Nathan Michael Trustee · Centralia, IAN25835Etheredge William T IV · Texas City, TXN2583CWarner Mitchel K · Kodiak, AKN2583FChatwell Terry D · Fort Worth, TXN2583HFly Again LLC · Tulsa, OKN2583JLauff Samuel Jr · Ocala, FLN2583LMontgomery Robert A · Hampstead, NCN2583UUfly Vi LLC · St Thomas, VIN2583ZTaildraggers LLC · Caledonia, ILN2584CMoreman Wiley E · Willcox, AZN2584FAdvanded Helicopter Concepts Inc · Frederick, MDN2584JVolar LLC · Forest, MSN2584URedd David C · Blanding, UTN25850Morey Airplane Co Inc · Middleton, WIN2585CGillum Colton M · Ontario, ORN2585FDobberfuhl James P · Clinton, WAN2585LAerospace Quality LLC · Piggott, ARN2585NChandler Ronald James Seth · Tucson, AZN2585ULionudakis Michael A · Scotts Valley, CAN25863Philips Joe C · Bryan, TXN2586FLofstrom Caleb J · Wasilla, AKN2586JHenegar Nathanie L · Owasso, OKFirst renewal noticeN2586LRuiz Edinson · Bakersfield, CAN2586NNoblin Michael A · Readyville, TNN2586UMaynor Roy · Brazoria, TXN2587FPutt Putt Pilots LLC · Xenia, OHN2587UEt Flight LLC · Cedar Park, TXN2588JShannon Noah Chad · Lawrenceburg, TNN2588NSchweller James O · Centerville, OHN2589NOlson Andrew J · Vail, AZN2589VGraveson John W · Uxbridge, MAN2589YOrtner Airport LLC · Wakeman, OHN2590DJenkins Richard E · Grants Pass, ORN2591DRootvik Dennis L · College Place, WAN2591JNagel Larry A · Hurricane, UTN2591LHettenbach Paul A · Carrollton, TXN2592DSweet Warner Sr · Wakefield, RIN2592JParker Alan K · Lenoir, NCN2592NEdwards Christopher V · Seattle, WAN2593LDaly Moses M · Underhill, VTN2593UCamara Cesar David · Plumas Lake, CAN2593VKenyon Chad J · Sterling, AKN2594DSwift John P · Enfield, CTN2594LSheldon Paul T · Saint James, MNN2594YBruns John R Jr Trustee · Floyds Knobs, INN2595FDowell Grant A · Lansing, MI
Back to AD 94-05-05 R1