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.
N3672CWells William · Cary, NCN3672KEgbert Colton T · Fernley, NVFirst renewal noticeN3672NSonger Dylan · Veedersburg, INN3672PSinnott-Simonis Lyle · Girdwood, AKN3672QDye Laura G · Whispering Pines, NCN3672UD W Clark LLC · Newton, NJN3672YN3672y LLC · Ferrysburg, MIN36730Jones Kevin B · Mineral Wells, TXN3673MBeacon Park Pointe LLC · Orlando, FLN3673PWikle Lori Ann · Glennallen, AKN3673RArtie Aircraft LLC · Trenton, MON3673UCastor Care LLC · Mount Pleasant, SCN3673ZMcmahan Harley B · Gakona, AKN36749Air Smt LLC · Powell, OHN3674DUS Flight Academy International Inc DBA · Post, TXN3674GSudduth Ronald C · Lineville, ALN3674NWitt Larry · Waco, TXN3674ZLohse William F · Carter, MTN36755Smith Andrew J · Port Alsworth, AKN3675CBergstrom Dean A · Watertown, CTN3675QSwann Phyllis R · Madison, ALN3675RCl1 LLC · Baton Rouge, LAN3675TFairbairn Stephen C · Carmel, INN3675WWilson Ag Consulting LLC · Boise, IDN3675YShettle Jay E · Berryville, VAN3675ZStangel Richard C · Enterprise, ORN36768Miller Thomas O · Ingalls, KSN3676CBoyce Walter Doug · Palmer, AKN3676EPiper Aircraft Inc · Vero Beach, FLN3676LAssociated Aircraft LLC · San Diego, CAN3676PThomas Steve L · Presho, SDN3676QJobe Eric J · Parkville, MON3676RRaider Aviation LLC · Lubbock, TXN3676UGregg Michael · Orlando, FLN3676XLeszczynski Walter D · Georgetown, KYN3676ZWhisair LLC · Little Rock, ARN36773Scootair LLC · Alburgh, VTN36774Mader David B · Biddle, MTN36777Litwin Linda J · Potomac, MDN3677MKetchum Jeremy W · Wasilla, AKN3677PZimmerman Harvey · Shelby, OHN3677UNinomiya James T · Placitas, NMN3677WGriffith Chad Wayne · Crosby, TXN36781Addison Thomas P · Haines City, FLN36787Manairco Inc · Wooster, OHN36789Paschke Jay · Weatherford, TXN3678LAerojet Services Inc · Aurora, CON3678MCometair LLC · Greensboro, NCN3678PFriemel & Sons LLC · Groom, TXN3678UCaven Dennis L · Santa Rosa, CA
Back to AD 2007-04-19 R1