AD 94-05-05 R1
Registered aircraft · 26,230
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.
N1402FRegistration Pending · Pomona, CARegistration pendingN1402NBauman Scott H · Long Valley, SDN1402YRg Enterprises LLC · Tullahoma, TNN1403FGoedeker Jr Werner F · Waterville, NYN1403HSutter Richard J · Kooskia, IDN14055Top Hand Inc · Laurel, MTN1405YImrich Thomas S · Mercer Island, WAN1406BBadenhorse Frans · Hawthorne, FLN1406EJeffries Joy L · Louisville, KYN1406VRegistration Pending · Wilmington, DERegistration pendingN1407BAufdencamp Timothy E · Bloomdale, OHN14084Chizek Terry L · Marion, KSN1408DParks James M · Potsdam, NYN1408UAircraft Guaranty Corp Trustee · Oklahoma City, OKN1408YShawver Aviation LLC · Knoxville, IAN1409DArcher William Todd · North Pole, AKN1409EMattson Eric J · Saint Paul, MNN1409HLissow William M · New Port Richey, FLN1409QDjz Aviation LLC · Kalispell, MTN140ABWiliams Steve C · Elgin, SCN140BTThomas Raymond · Deer Park, WAN140CBVintage Aircraft LLC · Gilbert, SCN140CEClawson Duane W · Enon Valley, PAN140CFBowser Brett A · Murfreesboro, TNN140CRWills William J · Cape Coral, FLN140CSIsrael Oscar M · Sinton, TXN140DConant Stephen · Nyssa, ORN140DTKing Jeremy S · Rainier, WAN140DWMuriithi Peter K · Middle River, MDN140EDThompson Randy L · Anderson, CAN140EWSouthern Aircraft Consultancy Inc Trustee · Casper, WYN140FLittlefield Molly Flanagan · Kent, WAN140GStong Douglas R · Collegeville, PAN140JHOhlin Christian A · Sebastopol, CAN140JTChristianson Alan J · Camas, WAN140JZLawrence John Z · Kingston Springs, TNN140KYCarpenter Michael A · Jefferson, ORN140LAAllen Lynn A II · Waxahachie, TXN140LBBerry Brian R · Tahlequah, OKN140LDMazankowski Lara R · San Diego, CAN140LMLambson Roger S · Saint Ignatius, MTN140MAMindy Limited LLC · Muscatine, IAN140MENorah Bridget · Snoqualmie, WAN140MQWasem John S · Nome, AKFirst renewal noticeN140MTHoover Josiah E · Wasilla, AKN140MWWeyant Charles B · Santa Maria, CAN140NJames Justin C · Pima, AZN140NSSwann Neal P · Plymouth, CAN140NTFlight International Inc Trustee · Dover, DEN140PClass A Coaches LLC · Missoula, MT
Back to AD 94-05-05 R1