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.
N8541TShepard Robert B · Minden, NEN8544TRose Don G · Winnsboro, TXN8545SRnr Aviation LLC · Malaga, WAN8546QBlack Andrew J · Broomfield, CON8546THoopes Aviation LLC · Carey, IDN8549TGagnon Nels D · Globe, AZN854CPCivil Air Patrol · Maxwell Afb, ALN854DZHohnadel R Michael · Harlingen, TXN8551SOpticalx LLC · Tracy, CAN8552SRtd Farm Inc · Fort Benton, MTN8554TDrake Robin G · Loganville, GAN8555SBray Harvey G · Reidsville, NCN8556SRoyalty Marshall E · Seymour, INN8557SLittle River Aviation LLC · Tifton, GAN8559SHanson Robert J · Renton, WAN8559TNorstegaard Mark A · Sturgis, SDN855BDThompson Contracting Inc · Peachtree City, GAN855PMSchroeder David W · Brutus, MIN855SPKirschner Joel D · Clarkesville, GAN8560QLunati Ralph · Mc Alpin, FLN8560TMcmaster John DBA · Wichita, KSN8561TScriver Cody M · Vashon, WAN8562TBacksen Rick L · Clarkston, WAN8564QEnvii Aviation LLC · Monroe, WAN8564TSpeer Gary L · Knoxville, TNN8565THarris Spraying Inc · Circle, MTN8566SVon Borstel Alan W · Grass Valley, ORN8566TWiggins Jeffrey W · Norwood, NCN856CSWendorf Bruce L · North Fort Myers, FLN8570QTwo O Six Inc · Fort Myers, FLN8570THeuett Clint James · Asotin, WAN8571SStevenson Intermountain Seed Inc · Ephraim, UTN8572RReese Owein · Glen Rock, NJN8572SPaulan Beverly S · Antioch, ILN8572TAerial Wayfarer LLC · San Antonio, TXN8573S182 Flight Corp · Bronx, NYN8575SDallas William J · Eastsound, WAN8575TChristensen Del S Trustee · Friendswood, TXN8576QThompson Robert Lee · Moore, OKN8577SRegistration Pending · Concord, GARegistration pendingN8579SHopp Gregory R · Columbus, OHN8579TGoldschmidt Scott · Cottonwood, CAN857NTSmeltz Kent · Dornsife, PAN857PDFelter John Vincent Jr · Lago Vista, TXFirst renewal noticeN8580QBald Eagle Aviation LLC · Oakley, UTN8580TBas Part Sales LLC · Greeley, CON8581FAccurate Aero LLC · Minden, NVN8581SBlack Samuel W · Kennesaw, GAN8583SDevillier Roland James · Winnie, TXN8584SRider Richard Trustee · Mill Valley, CA
Back to AD 84-10-01 R1