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.
N2977JBandy Suzanne M · Newport, ORN2977NFarrell Tammy J · Sterling, AKN2977VKnott Brody · Camarillo, CAN2978SRoach David · Modena, NYN2979DParker Benjamin E · Wasilla, AKN2979JStygar Richard M · Coal City, ILN2979ZHickle William H · Inyokern, CAN2980JOrsak Eddie J · Seymour, TXN2982HBarnstormers Club LLC · Cape Coral, FLN2982JTijman Esteban M · Potomac, MDN2982NNewman Richard D · South Beach, ORN2982SHerzog Daniel L · Clinton, MIN2983DIngalsbe David L · Flowery Branch, GAN2983NCmr Aviation LLC · Perry, UTN2984JBell Edward A · Richfield, OHN2984UJuris Ronald D · Bickleton, WAN2985JScott Jason Eton · Seattle, WAN2985NMcvay Myron A · Auburndale, FLN2985UConnersville Flying Club Inc · Connersville, INN2986JWylam Thomas S · Ocala, FLN2986NChartier Michael W · Las Vegas, NVN2986SHouglan Norman L · Shepherdsville, KYN2986ULuebke Austin D · Corsica, SDN29876Kegin Kevin M · Salem, ILN2987DScheda Mark R · Brockport, NYN2987UMott Charles A Jr · Chesapeake, VAN2988DBrown Hector M · Glenwood Springs, CON2988HKramer Craig W · Dyersville, IAN2988JRegistration Pending · Asotin, WARegistration pendingN2988UFrost Eddy L · Bishop, TXN2989JWright Brandon C · Cave City, KYN2989UGodinez Mauricio U · San Diego, CAN298SQEastern Stearman Inc Trustee · Leesburg, VAN2990JHale Randall C · Bloomburg, TXN2990NPaulson Michael J · Fargo, NDN2990SAndresen Paul S · Chandler, AZN2990UShiny Pigeon LLC · Fort Worth, TXN2991SVanbrocklin Valerie A · Anchorage, AKN2991UNeary Joseph P · Lindenhurst, ILN2992DArnold Scott M · Peachtree City, GAN2992SN2992s LLC · Bristol, VTN2993DBcw Aviation LLC · Sigourney, IAN2993KLee Robert E · Medford, WIN2993SCintron Jaime · Lake City, FLN2993U63 Aviation LLC · Petoskey, MIN2993ZKrupinski Floyd M · Chugiak, AKN2994DAncam Lc · West Burlington, IAN2995DPapoulias Michael A · Jackson, MIN2995SWillard Kevin C · Bartlett, NEN2996DParker Stephen H · Montgomery, TX
Back to AD 94-05-05 R1