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.
N419CCHills Craig · Avon, INN419CDRsk Aviation LLC · Midland, MIN419CMN419cm LLC · Bloomington, ILN419CPCivil Air Patrol · Maxwell Afb, ALN419CSGarza Richard · Monterey, CAN419DTurner Spencer A · Modesto, CAN419DMNote Clayton R · Eagle Point, ORN419DSLien Christian B · Rapid City, SDN419EPEpic Aviation Inc · New Smyrna Beach, FLN419FKlenoski Brian D · Fulton, MIN419FRAtp Aircraft 8 LLC · Wilmington, DEN419GCareer Pilot Training LLC · Wilmington, DEN419JARaw Aviation LLC · Wichita, KSN419JNWheeler Kelly · Columbia Falls, MTN419JRRaf LLC · Lenexa, KSN419KSClear Blue Aviation LLC · Hayden, IDN419KTAlizadeh Benjamin J · Placerville, CON419LJGowenmleah Jill · Lawrenceburg, TNN419LKSluka Christopher · San Diego, CAN419MGAnderson Todd · Bondurant, IAN419PASkywest Leasing Inc · St George, UTN419PHTaylor Septic Services LLC · Deltona, FLN419RStruthers Robert J · Geneva, ILN419SGilpin Nathan L · Cornelia, GAN419SAStephens Kristi J · Bellingham, WAN419SBLipscomb Brian · Fulshear, TXN419SFTotal Flight Aircraft Leasing LLC · Apex, NCN419STMyers Steven L · Goodyear, AZN419TN419t LLC · Boise, IDN419TEEp Enterprises Inc · San Juan, PRN419TFLee General Management LLC · Olive Hill, KYN419TRAmundsen John D · Soldotna, AKN419WAnn Arbor Flyers Inc · Ann Arbor, MIN419WPHole Jeffrey Wayne · Stockton, CAN419XBellamy William J · Duluth, MNN41ARobertson Roy E · Marion, IAN41ABBauermeister Aida · Tw 10 SjaN41ACPitts Flying Club Of Stoughton · Stoughton, WIN41AEBowen Haldor S · Sandpoint, IDN41AGSkyline Agrinautics Inc · Osage, IAN41AMStephens Calvin · Adrian, GAN41ANCampbell Ian · Miami, FLN41APRising Wings Aviation Inc · Casper, WYN41AWWalker James A · Birmingham, ALN41AYHunterdon Aviation Inc · Ringoes, NJN41AZAlexander Peter · Palo Alto, CAN41BBVagabond Air LLC · Dover, DEN41BEVintage Aero Collection Inc · Wilmington, DEN41BJJames Robert D · Anaheim, CAN41BKAmerican Classic Aero LLC · Kalispell, MT
Back to AD 2007-04-19 R1