AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N300PJLegacy Of Speed LLC · Warsaw, INN300PM300pm LLC · Bloomington, INN300PSRight Coast Ventures LLC · Royse City, TXN300QRPdq Flight Inc · Garden City, NYN300REMoreau Leo B · Wasilla, AKN300RFRivers Robert A · Oxford, NCN300RGRein Richard C · St George, UTN300RJTcj Kqc LLC · Robstown, TXN300RRRegan Richard Michael · Leesburg, VAN300RTChoux Aviation LLC · Cypress, CAN300RVHall Farms Inc · Garfield, KSN300RWWilliams Ray L · Chapmansboro, TNN300SAWhalen Sean B · Naples, FLN300SBGustafson Cody A · Corvallis, ORN300SKKayrouz Sebastien V · Richardson, TXN300SQVortex Aviation LLC · Houston, TXN300SXSpencer Scott V · Washington, UTN300TFSouthern Cross Aviation Inc · Wilmington, DEN300THPacific Flight Academy LLC · Honolulu, HIN300TLAlls Peyton H · Raleigh, NCN300TTDg Aero LLC · Little Rock, ARN300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKN300UHAlba Leasing Services LLC · Scottsdale, AZN300UMMurray Air LLC · Patoka, ILN300UPNeo Terra Aviation LLC · Setauket, NYN300VCReam Real Estate LLC · York, PAN300VTCarroll James K · Klamath Falls, ORN300WBarn Miami Inc · Miami, FLN300WDPlane Fun Inc Tr Trustee · Snellville, GAN300WEK & S Aero LLC · West Chester, PAN300WFAmoth Kurt J Trustee · White Salmon, WAN300WLRosen Robert D · Lewisville, NCN300WSOdyssey Aviation LLC · Raleigh, NCN300WYChupka William J · Riverton, WYN300WZNicholas Christopher · Williamsville, NYN300XASale Reported · Henderson, NVSale reportedN300XTExtra300 LLC · Anchorage, AKN300YBGospel Ministries International Inc · Collegedale, TNN30101Sunrise Aviation Inc · Ormond Beach, FLN3010ELenzen Richard D Dr · Antioch, ILN3010GJerry Slough Aviation LLC · Bakersfield, CAFirst renewal noticeN3010KGoodwin David · Edinburg, NYN3010LJones Johnny R · Thermopolis, WYN3010TBb Air Corp · Tulsa, OKN3010WSunwest Aviation Inc · Santa Ynez, CAN3010XHelifun LLC · Austin, TXN3010ZClemente Matthew J · Troy, NYN30112Leonard Kevin J · Wagner, SDN30114International Aviation Group LLC · Lake Wales, FLN30116Registration Pending · Benson, AZRegistration pending
Back to AD 2007-04-19 R1