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.
N4830FRitzman Todd F · Pewaukee, WIN4830GHawaii Pacific Aviation Inc · Kailua Kona, HIN4830KRamaker LLC · Choteau, MTN4830LOne Niner Right Ltd · Bartlett, ILN4830NSimansky Daniel W Trustee · Van Nuys, CAN4830UUniversity Of Oklahoma · Norman, OKN4830VAkin Allen Kent · Midland, TXN4831DVogel Paul R · Valparaiso, INN4831FWillis Rodney S · Wasilla, AKN4831JSiewert Michael H · Columbus, OHN4831LMartinez Custom Homes LLC · Porter, TXN4831MBoty Aero LLC · Madison, ALN4831SRegistration Pending · Kodiak, AKRegistration pending, pending cancellationN4832DM & D Adventures LLC · Ozark, MON4832ESenn David L · Oak Ridge, TNN4832JApex Trucking Inc · Park City, KSN4832TVesely Paul T Trustee · Louisa, VAN4832UBryant David DBA · Athens, TNN4832YStohr Beuford G · Woden, IAN4833AEnoch Mark C · Rowlett, TXN4833CRossi A F · Belmont, CAN4833DSmith Shayne A · Greenville, TXN4833LAdbm LLC · Oldsmar, FLN4833NMegalith LLC · Belvidere, ILN4833PPacifica LLC · Grand Junction, CON4833TDodson International Parts Inc · Rantoul, KSN4834ANicoletti Will · Eagle River, WIN4834DGrismer Larry Trustee · Hemet, CAN4834ESweeney Michael J · Seattle, WAN4834KBurke Kenneth V · Payson, AZN4834LBell Hubert D · Lewiston, IDN4834QWavra Mark F · East Grand Forks, MNN4834SBuell Bay Co · Irvington, VAN4834UWoodley Michael J · Harrietta, MIN4834WParker Larry C · Roswell, NMN4835GFiedler Aviation LLC · Suffolk, VAN4835LSims Kyle Z · Locust Grove, GAN4835SHolder Jamie · Marionville, MON4835TPero Thomas E · Richland, MIN4835UHults David E · Gooding, IDN4836ASales Joe Haney · Seminole, TXN4836CSearfus Kirsten L · Durango, CON4836DRegistered aircraftN4836EOlson Philip R Trustee · Amity, ORN4836FGold River Aviation LLC · Rio Verde, AZN4836GEvolo Aviation LLC · Worthington, OHN4836LPeterson Wayne · Dexter, MNN4836QMcinelly Leon · Fairbanks, AKN4836SRegistration Pending · Maple Lake, MNRegistration pendingN4837ALongleaf Wing Ventures LLC · Birmingham, AL
Back to AD 2007-04-19 R1