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.
N4315VCustom Services Group Inc · Fort Walton Beach, FLN4315YThree Wing Flight School LLC · Stratford, CTN43160Dodson International Parts Inc · Rantoul, KSN43164Jasper Thomas Wesley · Monroe, NCN4316AHvizdak George D · Colliers, WVN4316HEvans William H Jr · Gardendale, TXN4316JAnderson Richard E · Indianapolis, INN4316RMarston Charles T · New Bern, NCN4316USkyborne Airline Academy Inc · Vero Beach, FLN4316WHolt Bartlett · Binghamton, NYN4316ZGardner Richard T · Delta Junction, AKN43170Craig John IV · Lilburn, GAN43171Flight Leasing Corp · Wilmington, DEN4317BParis Air Inc · Vero Beach, FLN4317DParis Air Inc · Vero Beach, FLN4317GCendejas Agustin · Chino, CAFirst renewal noticeN4317JMiller Anthony J · Rexford, MTN4317QPerera Nandana L · Logan, OHN4317RSam Aviation LLC · Long Beach, CAN4317TSpanku LLC · Bay Shore, NYN4317WMurray Patrick G · Moraga, CAN43181New Mexico Flying Eagle Inc DBA · Tucson, AZN43186Aerolina Inc · Hendersonville, NCN43187Frederick Aero Club Inc · Wilmington, DEN4318BFaith Flyers Inc · Wellington, FLN4318RBeaulieu Steven · Georgetown, DEN4318SFlite Solutions LLC · Beavercreek, OHN4318ZDodson International Parts Inc · Rantoul, KSN4319DPumphrey Anthony D Sr · Little Rock, ARN4319MSale Reported · Aptos, CASale reportedN4319RWoodland William B · Anchorage, AKFirst renewal noticeN4319SMac Air Inc · Farmington, MON4319XEagle Eye Aerial Imaging LLC · Chagrin Falls, OHN4319YRock Solid Aviation LLC · Lake Charles, LAN4319ZNorthland Hangars LLC · Palmer, AKN431ARegistered aircraftN431AFBuha Holdings LLC · Paris, TXN431BRLockyer Roch Jr · Austin, TXN431CDMother Of Perpetual Succor LLC · Villa Hills, KYN431CELegacy Aviation LLC · Ann Arbor, MIN431CPCivil Air Patrol · Maxwell Afb, ALN431CRAb Prop Plane II LLC · Metairie, LAN431DBDuininck Companies LLC · Prinsburg, MNN431DEClark Air Ventures LLC · Awendaw, SCN431ERegistration Pending · Kokomo, INRegistration pendingN431EAHamilton Dale N · Grand Rapids, MIN431FDahlin Joel R · Saint Paul, MNN431FPSky West Aviation Inc Trustee · Albuquerque, NMN431JDeboer Jon Tanner · Saginaw, TXN431JPJoerithan & Mp Aviation LLC · Whittier, CA
Back to AD 2007-04-19 R1