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.
N84447Ford Irby M · Pflugerville, TXN84450Beem Keith B · Clifton Park, NYN84451Wyatt Maryellen Personal Represenentative · Weirsdale, FLN84453Yennaco James F · Pepperell, MAN84457Doughty Michael M · Harrisburg, PAN84458Petty Edwin · Clanton, ALN84469Johnson Vernon C · Caledonia, NYN84475Finn Michael R · Maple Grove, MNN84480Champagne Richard W · Amelia Court House, VAN84482Ghafouri Mohsen · Murrieta, CAN84483Moore Eugene K · Portsmouth, OHN84485Nelson Jerry Leroy · Bronson, MIN84498Wald Leo F · Haines, AKN84499Buehler Andrew C · Eatonville, WAN84504Ebert Larry · Ashton, ILN84506Jjbk LLC · Bancroft, NEN84517Knutson Wayne R · Tioga, NDN84519Adams Patrick A · Louisville, KYN84520Hagedorn Matthew J · Prineville, ORN84522Peak Development Group Ubo · Gallatin Gateway, MTN84525Augustin Caleb J · Madison, ALN84534Inman Dentis · Whiteville, TNN84538Raser Gary D · Birdsboro, PAN84539Harry Thomas C · Boiling Springs, PAN84542Jones Duane R · New Carlisle, OHN84545Miller Cheryl B · Goode, VAN8454CJohn Linda M · Heathsville, VAN84550Huber Jacob P · Blue Earth, MNN84553Szewczyk Vincent F · Boonville, NYN84554Mostad James A · Minot, NDN84555Sandland Patrick W · Wasilla, AKN84556Jeffryes Richard B · Creswell, ORN84557Schwichtenberg David A · Jordan, MNN84562Johnson David H · Jasper, GAN84564Havener Hunter W · Chittenango, NYN84565Delaney Kevin P · Germantown, TNN84572Hartley Roger L · Moatsville, WVN84583Garcia Cabral Carlos N · Venetia, PAN84589Simpson Eugene W · Mount Gilead, NCN84591Parkes Kenneth J · Middleburgh, NYN84597Neal Craig L · Melissa, TXN845BCLauchland George M · Troy, IDN845TAirborne Perspectives LLC · Fort Collins, CON84605Sauter Allen · Bismarck, NDN84606Gregory Robert H · Glenwood, MNN84608Artlip James R · Wake Forest, NCN84609Danielson David · Hibbing, MNN84610Boatright Michael L · Live Oak, FLN84614Lokken Myron L · Madison, WIN84616Greenbrier Aviation LLC · Sevierville, TN
Back to AD 2000-25-02 R1