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.
N397WNWillis Donald C · Telford, TNN397XMikepaparomeo LLC · Bend, ORN39806Williams Jeffrey Thomas · Aurora, CON39807Sale Reported · Del Rio, TXSale reportedN39808Coen Brady L · Wiley, CON3980KStephen Reinhart Air LLC · Depew, NYN3980QLanning 1 Aviation LLC · Amarillo, TXN3980RMayor Michael E · Union, KYN3980UUniversity Of Oklahoma · Norman, OKN3980WJohnson Ralph W · Shelbyville, TNN3980ZMarschke Dean D · Excelsior, MNN39813Emde William C · Marina Del Rey, CAN39818Connell Edward A III · Crescent City, FLN3981DDuncan C Todd Consulting Services LLC · Tucson, AZN3981KLenko David J · Smyrna, DEN3981TThompson Lloyd M · Boise, IDN3981WDream LLC · Middletown, DEN3981ZSeeton Samuel · Casper, WYN39820Benkert Daniel D · Rapid City, SDN39826Chardon Stephen A · Franconia, NHN3982DA P Leasing Inc · Wilmington, DEN3982KElson Irving A · Rockville, MDN3982QSouther Field Aviation Inc · Americus, GAN3982WStrassfield Justin · Moyock, NCN3982XSauve Tiffany A · Racine, WIN3982ZDubious Adventures LLC · Big Lake, AKN39839Phillips John C · Gallina, NMN3983GBank Of Utah Trustee · Salt Lake City, UTN3983KDetroit Piper Sales & Service Inc · Pontiac, MIRegistration revokedN3983SPatterson Richard A · Clinton, SCN3983YMalpass William H DBA · Shreveport, LAN3983ZHanson Julie A · Anchorage, AKN39841Riggin Flight Service Inc · Madison, SDN39843Altounian Adam J · Charleston, SCN39844Aero-Spray Inc · Kingfisher, OKN39849Lowe Kenneth E Jr · Wooster, OHN3984DRaven Aviation LLC · Alexandria, VAN3984NSpencer Aviation Inc · Delaware, OHN3984PSnively Russell C · Lodge Gross, MTN3984QYarrington David W · Magnolia, DEN3984RThompson Jim R · Holdenville, OKN3984TParidee Kevin M Jr · Cumming, GAN3984ZSterling John · Port Lavaca, TXN3985Nighthawk N8231g LLC · Pompano Beach, FLN39856Zollars Byron · Georgetown, TXN3985NRobinett Christopher T · Oklahoma City, OKN3985PPrettyman Walter P · Valdosta, GAN3985QArnold Ralph F · Golden Valley, AZN3985RRealm Group Transport Inc · Las Vegas, NVN3985ZRatcliff Stephen B · Anchorage, AK
Back to AD 2007-04-19 R1