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.
N34506Tibbs Gary R · Marietta, GAN3450FPeeler Max H · Rock Port, MON3450SBoyes Robert Louis · Benton City, MON3450WRst Aviation LLC · Vero Beach, FLN3450XCarey Patrick M · Citrus Heights, CAN34511Mazure Glenn J · Bad Axe, MIN3451334513 LLC · Stanton, TNN34519Mccarthy James E · Yucca Valley, CAN3451FBonnett Bruce J · Azle, TXN3451KMorehead Matt F · Chico, CAN3451QCcr Holdings LLC · Rushford, MNN3451RBurkett Aerial Spraying · Coleman, TXN3451SChancellor Marvin E · Houston, TXN3451TMichael W Maciol Md · Pelham, NYN3451UJohnson Kevin S · Burns, ORN3451ZHarris Michael E · Greenville, SCN34521Mitchell Robert A · Centennial, CON34524Registered aircraftN34528Mcmahon John · Sequim, WAN3452DRault Jaimie E · Homer, AKN3452KRegistered aircraftN3452QGolden Arrow Transportation Co · Plainfield, NJN3452ROreagan Trenton David · Soldotna, AKN3452SWolff David Christian · Port Saint Lucie, FLN3452TKordus Robert A · Union Grove, WIN3452UNordland Tom Trustee · Boulder Junction, WIN3452YRegistered aircraftN3452ZChief LLC · Du Quoin, ILN3453QEdwards Latas L Jr · St Petersburg, FLFirst renewal noticeN3453TAircraft Evolution LLC · Miami, FLN3453WBrown Craig · Vernal, UTN34543Riggs Jeffrey W · Claremore, OKN34549Octans Aviation Co · Watertown, SDN3454TTears Gary S · Edmond, OKN3454WRoos Paul A · Lake City, FLN3454XGarcia Eduardo G · Houston, TXN34552Mlinarich Rob · Pottsboro, TXN34554Maryland Industrial Trucks Inc · Linthicum, MDN34555Cardinal Aviation LLC · Everett, WAN34556Thornsbury Nicholas J · Virginia Beach, VAN34557Podgwaite Frank C III · North Haven, CTN34559Bagley John C · Schertz, TXN3455AKoelsch Benjamin · Nome, AKN3455ESilverhawk Aviation Academy LLC · Caldwell, IDN3455FN3455f Aviation LLC · New Blaine, ARN3455NRegistered aircraftN3455RBulut LLC · Los Angeles, CAN3455SAcute Holdings LLC · Jenks, OKN3455TCornejo Jose Valente · Scottsdale, AZN3455WClark James A · Walnut Creek, CA
Back to AD 2007-04-19 R1