AD 2000-25-02 R1
Registered aircraft · 7,563
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:2000-25-02-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:2000-25-02-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:2000-25-02-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:2000-25-02-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.
N83975Driskill Lincoln · Devils Tower, WYN83976Whittington John H Jr · Rowland, NCN83981H J Champion LLC · New Windsor, NYN83982Clark William · Easton, MON83984White Paul M · Elizaville, NYN83987Betzoldt Dan A · Tecumseh, MIN83989Bentley John R · Bend, ORN83991Davis James C · Modesto, CAN83992Mandala Michael L · Chowchilla, CAN83994Rausch John C · Upland, CAN83995Dugger Timothy E · Anderson, AKN83996Keisler Homer L · Lexington, SCN83997Fuentes Hansen B · Louisville, KYN83DHHansen Douglas M · Garden City, SDN84002Registered aircraftN84003Shiner Stephen M · Marshfield, WIN84004Swenson Leroy D · Le Sueur, MNN84006Mueller David C · Fremont, NEN84012Berghoff Lewis · Selmer, TNN84016Plane Trail LLC · Mccook, NEN84018Johnson Bennett · Everett, WAN84020Baker Robert · Dorr, MIN84021Hart Timothy S · Apison, TNN84025Griesman Scott W · Sandy Valley, NVN84028Kranz Michael J · Castlewood, SDN84029Chase Michael D · Sonora, CAN84030Lester Gordon W · Corpus Christi, TXN84031Hamilton James S · Decker, MTN84032Eide Donald B Trustee · Webster, MNN84033Schmitt Zachary J · Nordman, IDN84035Howell John R · Bertram, TXN84046Bowman Stephen Lee · Palm Bay, FLN84049Link James L · Raleigh, NCN84053Mandala Mike L · Chowchilla, CAN84056Registration Pending · Carmi, ILRegistration pendingN84059Lsa Flight LLC · Louisville, KYN84067Srofe Danny D Jr · West Portsmouth, OHN84069Kim Jonathan · Abilene, TXN84070Kraft Ag Aviation Inc · Mapleton, NDN84074Abbe Thomas E · Wasilla, AKN84075Normark Nancy · Weirsdale, FLN84080Thomas Richard E · Lafayette, TNN84081Pedri Michial A · Cool Ridge, WVN84083Cottrell Alan L · Toano, VAN84084Airknocker LLC · Vidalia, LAN84091Nantz William G · Raleigh, NCN84096Walls Sales LLC · Poplar Bluff, MON840WAOwatonna Warrior LLC · Owatonna, MNN84100270 Aero LLC · Fulton, KYN84111Boggs Aerospace LLC · Keyser, WV
Back to AD 2000-25-02 R1