AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N9314XFortney Rick · Mc Alpin, FLN93157Haley Mitchell P · Big Lake, MNN9315C15charlie LLC · Soldotna, AKN9315XBowen Floyd Eugene Jr Trustee · Bend, ORN9316XZilberberg Tamir · North Hollywood, CAN9317Avignati West LLC · Santa Barbara, CAN9317ACunningham Kenneth R · Lawton, OKN9317CSixus LLC · Fairfax, VAN9317EBrothers Brian · Columbus, OHN9317MWestwind Aviation Inc · Phoenix, AZN9317WBruton Paul R · El Campo, TXN9317XMoonshine Energy LLC · Midland, TXN93186Bates Byron B · Ethel, WAN9318ASmith Michael Todd · Edgerton, MON9318XTopnotch Aero Inc · Austin, TXN9319AMyers Alan J · Danville, ILN9319XShepherd Joseph R · Fayetteville, GAN931EMClackamas County Sheriffs Office · Oregon City, ORN931SJTss Flying Club Inc · Bethesda, MDN9320CRiley Coda L · Beaumont, TXN9320GChiles Farms LLC · Hooper, CON9320XBlue Skies Air LLC · Portland, ORN9321GFontana Michael A · Kirkwood, MON9321XSakonnet Aircharter · Bradenton, FLN9322ALeamon Douglas H Trustee · Stockwell, INN9322GHutchinson Darrold Trustee · Hingham, MTN9322XCivil Air Patrol Inc · Maxwell Afb, ALN9323XBertelsen Sven Erik · Gulfport, FLN9324ABoswell Kurt R · Renton, WAN9324CWillig Zachary · Angola, INN9325ABarron Aviation LLC · Perry, MON93260Webb Michael · Magnolia, TXN93262Land Office LLC · Burlington, CON93274Wltf LLC · Caldwell, IDN9327ERhoades Christine · Laguna Beach, CAN9327XHull Ray · Waynoka, OKN93285Corrie Brent · Vero Beach, FLN93295Gates Steven · Midlothian, TXN9329CWoodcock Tanner E · Red Lodge, MTN932DBVanvalkenburg Eric · Hudson, WIN932FWJones Joseph A · Covington, WAN9330ACrh LLC · Middlebury, CTN9330CAircraft Structural Repair Inc · Hamilton, MTN9330GHarris Ryan C · Gurley, ALN9331CLodato Zack · Wenatchee, WAN9332HLeppke Lyle K · Marion, KSN9332TMiller Aircraft Services Inc · Crookston, MNN9332XM & D Blomquist LLC · Central Valley, UTN93330Burden John C · Decatur, TXN9333CDunkley Bret Y · Kotzebue, AK
Back to AD 84-10-01 R1