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.
N4096DSkydive Cape Cod Inc · Caddo Mills, TXN4096ESwiss John T · Anchorage, AKN4096SSmith Timothy M · Mount Pleasant, WIN4096XFoster Robert L Jr · Chandler, OKN4096ZTurner Hal Eugene Jr · Tiburon, CAN40972Terry Aaron D · Glendale, AZN40978Dodson International Parts Inc · Rantoul, KSN4097LSinkule Jim · West, TXN4097MN4097m LLC · Boynton Beach, FLN4097XWilson Dane A · Church Point, LAN4097ZSullivan Daniel J · Long Lake, MNN40982Seneca Aviation LLC · Wheaton, MDN40984Four Zero Niner LLC · Granger, IAN40987Besl Thomas J · Cincinnati, OHN4098DAspegren Robert N · Vacaville, CAN4098FN4098f LLC · Ypsilanti, MIN4098XOstgard William R · Mims, FLN4098ZChant J Archie · Riverton, WYN40993Premier Capital Enterprises LLC · Hurricane, UTN4099EReel Chad · Wasilla, AKN4099NS O Witt And Associates LLC · Ridgecrest, CAN4099SDodson International Parts Inc · Rantoul, KSN4099XMiller Aviation Group LLC · Coon Rapids, MNN4099ZMayes Brett R · Williams, CAN409ACHighland Holdings LLC · Bethlehem, PAN409AFThomas Douglas M Jr · Blue Bell, PAN409BKHyannis Air Service Inc DBA · Hyannis, MAN409BWBarrett Transportation LLC · Mount Pleasant, TNN409CACoast Flight Training And Management Inc · Dallas, TXN409CCPappy Air LLC · Pickerington, OHN409CDArmbruster LLC · Amherst, OHN409CQPaper Airplane Co LLC · Broomfield, CON409CRChristiansen Aviation LLC · Wilmington, DEN409CVCivil Air Patrol · Maxwell Afb, ALN409DParagon Flight Training Co · Fort Myers, FLN409DCSpitzer Helicopter LLC · Wilmington, DEN409ESN409es LLC · Stuart, FLN409FDSouth Seas Aviation Ltd · Wilmington, DEN409FPAamro Aviation Corp · Lake Worth, FLNon-citizen corporation, flight hours not reportedN409JBPenstar Partners LLC · Wilmington, DEN409KJBoard Of Trustees · Battle Creek, MIN409LAAnderson Wilma (Lori) · Blue Mound, ILN409LPSolberg Aviation Co Inc · Whitehouse Station, NJN409MFenton Richard O · Weatherford, TXN409MBNiner LLC · Wilmington, DEN409MMStormer Isaac E · Curtis, WAN409NSGonzalez John E · Malibu, CAN409PValiair Limited Co Trustee · Casper, WYN409PDIowa Great Lakes Flyers Inc · Cheyenne, WYN409PKSky Cowboy Supply Co LLC · Cape Elizabeth, ME
Back to AD 2007-04-19 R1