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.
N458KGAircraft Guaranty Corp Trustee · Oklahoma City, OKN458LBBeedy Lyle G · Derby, KSN458LTN87bb LLC · Monroe, NCN458ME1st Avenue Ttc LLC · Los Angeles, CAN458RHHamil Robert D · Houston, TXN458RVRussell Steven J · Wilmington, ILN458SCAb Prop Plane I LLC · Metairie, LAN458SGCedar Ridge Aviation LLC · Knox City, TXN458SKKroenke Seth M · Palmer, AKN458SPChristiansen Aviation LLC · Wilmington, DEN458SRDr2 Aviation LLC · Valdosta, GAN458SSSos Ranch LLC · Humble, TXN458TCyclone Services LLC · Fife, WAN458TWFirst Aviation Co · Prospect Heights, ILN458UZStoik David E · Prunedale, CAN458WTls Aviation LLC · Smyrna, TNN458WCSee Forever Holdings LLC · Wilmington, DEN4590AEllis Darry Lynn · Wasilla, AKN4590FDavid Badaczewski · Gettysburg, PAN4590JEpic Aviation Inc · New Smyma Beach, FLN4590ROzar Abdurrahman · Virginia Beach, VAN4590SConner Chad E · Paris, TNN4590TOdonald John C · Greenville, MIN4590WBfi Financial Alliances Limited LLC · Cave Creek, AZN4591HCampbell James R · Bennett, CON4591KDesmon David L · Everett, WAN4591RJohnson Robert B · Wichita, KSN4591TCherokee 235 LLC · Sidney, NEFirst renewal noticeN4591WRojas Franklyn N · Ocala, FLN4591XCoral Air LLC · Rock Rapids, IAN4592SMays Robert · Centerville, TNN4593ABvm LLC · Stonington, CTN4593BSale Reported · Anchorage, AKSale reportedN4593FSterling Flight Training LLC · Jacksonville, FLN4593VFranklin Eric J · Anchorage, AKN4593XClubs 2 LLC · Calabasas, CAN4593YSoaring Society Of Boulder · Boulder, CON4594CSt Johns Aviation LLC · Saint Johns, MIN4594ELingo Joshua B · Lake Village, ARN4594F181 Corporation · Charlotte, NCN4594REkblad Carl Allyn · New Port Richey, FLN4594XAdventure Ventures LLC · Salem, CTN4595BBartusek Donald L Trustee · Columbia, MDN4595FSchroeder Herbert D · Plano, TXN4595JPetesch Andrew L · Meriden, KSN4595SHurst Sheldon G IV · Smyrna, GAN4596BLow & Slow LLC · Columbus, OHN4596FJaysix LLC · Greeley, CON4596SWaters Mark N · Clovis, NMN4596URustair Inc · Anchorage, AK
Back to AD 2007-04-19 R1