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.
N8947RUpton Chris M · Hettinger, NDN8948RWhomble Leonard L · Wray, CON8949RMorten Jesse L · Larimore, NDN8951RGardner John B · Arlington, INN8952RBaker Charles L · Swartz Creek, MIFirst renewal noticeN8956Martini Philip D · Bethel Park, PAN8958English John H · Pittsburg, TXN8965RAspenglow LLC · Talkeetna, AKN8967RWindsock Holdings LLC · Amarillo, TXN8969RRutland Aviation Service Inc · Tifton, GAN8970RMerrell Susan E · Midland, MIN8973RDilliha Steve G · Russellville, KYN8977RCozine Mark R · Cherokee, IAN8978RRoth Robin A · Wray, CON8979RSeeley Lenard D · Osage, WYN8980RHolmes Aviation Inc · Cannon Falls, MNN8981RBlock Raymond J · Palmer, AKN8982RBoo Steven R · Chisago City, MNN8985RChapman William H · Dayton, OHN8986RYarbanton John Robert · Muskegon, MIN8988RYoung Andrew J · Eagle River, AKN898TKatz Air Holdings LLC · Wilmington, DEN8993RMiller Scott A · Piney Flats, TNN89946Safran Brian J · Valley City, OHN8994RT & H Aviation LLC · Rector, ARN8999RDetroit Lakes Aviation Inc · Detroit Lakes, MNN89GKCasa Jets Inc · Pittsford, NYN89MMSic Sac Fliers LLC · Gainesville, FLN89TWAlpine Aerobatics LLC · Chelsea, MAN89WSStevenson Wayne · Georgetown, MNN8CJBrothers Aviation LLC · Black Rock, ARN8CKPresley Danny K · Homer, AKN8DBBaker Drew A · Little Rock, ARN8DLKnowlton James W · Au Gres, MIN8ETAshby Dennis A · Paris, TXN8PMChristmas Michael G · Long Beach, CAN8QPBurwell Shawn J · Elkhorn, NEN8RRCarey Patrick T · Hawthorne, CAN8SFScarbrough Christopher R · Palestine, TXN8UKIvey Thomas S · Gladewater, TXN8ZXKansas Farm And Ranch Inc · Seneca, KSN9000BHanna Ryan D · Berthold, NDN9001EWiencek Karl · Huddleston, VAN9002BWicklander Richard O · Spanaway, WAN9004LThoman Mark C · Jacksonville, NCN9005BSchorsch Cary J · Franksville, WIN9005LColorado Twin Bonanza LLC · Broomfield, CON9006EMiller Bruce A · Plano, TXN90076Tilts Brandon J · Flagstaff, AZN9007EFolbre Frank S · Millsap, TX
Back to AD 2000-25-02 R1