AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N5467ZWilliams Mark L · Denham Springs, LAN54680Yanagida Kazuaki · Norco, CAN5468HPrjc Properties LLC · Vonore, TNN5468LStewart Kenneth R · Allen, TXN5468PThompson Kevin A · San Rafael, CAN5468RCw Arborists Ltd · Killingworth, CTN5468WSitton David F · Mebane, NCN5468ZJensen Larry F · Millington, MIN5469HBonny Brad J · Sunnyside, WAN5469KAviation Specialists Inc · Apison, TNN5469LHovanec Robert R · Mineral Ridge, OHN546ASouthern Illinois University · Murphysboro, ILN546BNavigation Leasing LLC · Castle Rock, CON546CACoast Flight Training And Management Inc · San Diego, CAN546CWCentral Washington University · Ellensburg, WAN546DKMcghee Billy H · Deland, FLN546EREmbry Riddle Aeronautical University Inc · Prescott, AZN546HPSwisher Aviation LLC · Auburn, NHN546KWard Mark E · Brookfield, WIN546MCLeaseair LLC · Wilmington, DEN546NDSpartan Education LLC · Tulsa, OKN546PSClimb LLC · Kalispell, MTN546SCWessel Marvin E Jr · Camp Verde, AZN5470KSkye Aircraft LLC · Deland, FLN5470WRegistration Pending · Bulverde, TXRegistration pendingN5470ZGordon Robert F · Collins, MON54715Apt Aero LLC · Port Angeles, WAN5471LJc Investors Group LLC · Coral Springs, FLN5471PN5471p LLC · Roswell, GAN5471WBartholomew Charles Scott · Newburyport, MAN54728Vig Cheryl J · Opal, SDN5472HBertrand Joel R Trustee · Anchorage, AKN5472RAnderson Craig D · Mission Viejo, CAN5472TAdvantage Aviation Inc · Palo Alto, CAN5472ZBanks Steven R · Blue Springs, MON54733Gofastpilots LLC · Roswell, NMN54734Southern Arkansas University Tech · Camden, ARN54739Skylens LLC · Hammond, LAN5473DN1705r Inc · Cobb, CAN5473HSkatvold Charles P · Moorhead, MNN5473LPlane Fun Inc Tr Trustee · Snellville, GAN5473PBloyer Kelly G · Townsend, GAN5473TTiernan Barton M · Anchorage, AKN5473WMathews Derek A · Burlington, KYN54741State Of Alaska · Anchorage, AKN54744Suncoast Aviation Of Swfl LLC · Fort Myers, FLN5474PKrnp Air Services LLC · Zeeland, MIN5474SHiggs Mark P · Monett, MON54750Heartland Aviation Inc · Alliance, NEN54752Aerosync LLC · Miami, FL
Back to AD 81-18-04 R2