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.
N47GFGlobal Flight Support And Sales Inc · Tampa, FLN47HBSparks John Jr · Orange Beach, ALN47HJWhite Billy C · Baker, FLN47HYJoseph C Thomas · Lenoir, NCN47JBBean Jackson A · Quinlan, TXN47JEHurley Nicholas John · Trinity, NCN47JGCorcoran Peter A · Fallbrook, CAN47JLElliott David Robert · San Jose, CAN47JQJaquish William E · Tunkhannock, PAN47JTM & M Investments Of Jonesboro LLC · Jonesboro, ARN47KABroom John F · Sherman, TXN47KKHermansen Dane K · Ormond Beach, FLN47KSReiland Daniel E · Spring Valley, MNN47LMelugin Michael R · Manteo, NCN47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLN47LLSmith Roy H · Garberville, CAN47LULetourneau University · Longview, TXN47MDBrambles Inc · Bakersfield, CAN47MEN47me LLC · Tampa, FLN47MKAztec Aviation Two LLC · Augusta, GAN47MLWitt Jerry D III · Houston, TXN47NFAndrews University · Berrien Springs, MIN47NLAnton Billy V · Satanta, KSN47NZFish Dwain E · Silver Springs, NVN47PGRandall Skye Sanjay · Lansdowne, PAN47PHReal Time Aviation LLC · Southlake, TXN47PLGreer Wesley E · Woodstock, GAN47PSPalm Springs Air Museum Inc · Palm Springs, CAN47RGGossard Philip G · Stonington, MEN47RTBas Part Sales LLC · Greeley, CON47RWSale Reported · Glen Allen, VASale reportedN47SSandlapper Aviation Of De Inc · Bennington, VTN47SDWampler William C · Canton, TXN47SPDurham Rex L · Blakely, GAN47SRRendezvous T82 LLC · Mansfield, TXN47STFuhs Nicholas J · Advance, NCN47TCWright Frank David · Sequin, TXN47TDBeene Donald · Westfield, INN47TGTan Industries LLC · Wilmington, DEN47TLObendorf Phillip G · Parma, IDN47TNFlight Operations Aircraft LLC · Wilmington, DEN47TSStewart Terry · Anchorage, AKN47TWRiley Steven M · Bucyrus, KSN47TZZilka Timothy R · Alpine, WYN47UAleco 182 LLC · Vestavia Hills, ALN47UTHogan Robert Wayne · Gainesville, TXN47VMCox Michael · Casper, WYN47WCFly Girls Aviation LLC · Saint Amant, LAN47WK57 Bw LLC · Reno, NVN47WLSchettler Patrick J · Garnett, KS
Back to AD 2007-04-19 R1