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.
N491AFMeyer Terry L · Wayne, NEN491CCBarbee Johnny Lee · Fort Stockton, TXN4920ABerry Thomas R · Anchorage, AKN4921AHogan William J · Libby, MTN4921DMills Air Service Inc · Marstons Mills, MAN4921FCa Aviation 172 LLC · Santa Barbara, CAN4922HOptic Air LLC · Maurice, IAN4922YHowey Aviation LLC · Woodhaven, MIN4923ADaniel Arthur D · Fishtail, MTN4923UUnited Indian Missions Inc DBA · Tucson, AZN4924AMachnik Todd J · Old Lyme, CTN4924DRobinson Anthony D · Brookshire, TXN4924UScheren Raymond D · Johnson, VTN4925QEsty Effew LLC · Wimberley, TXN4926AEngland John James · Montrose, CON4927NRmst LLC · Mason, OHN4927SDaniel L Voiers · Hephzibah, GAN4927UBetz Brett A · Reminderville, OHN4929AApling Randall L · Wasilla, AKFirst renewal noticeN4929CBerry Darrel · Camden, TNN4929DUnion Flyers LLC · Union, SCN4930ACapra Cory · Forest Lake, MNN4930DToribio LLC · San Antonio, TXN4930NOneill Aviation LLC · Lake Wales, FLN4932ALegas David S · Phoenix, AZN4932NSan Juan Flyers Inc · Pagosa Springs, CON4932SThunder Aviation LLC · Oro Valley, AZN4933SHedden Larry H · Huntsville, ALN4934AYellowstone Overflight Inc · Belgrade, MTN4934SFerrell Charles A · Stockton, CAN4934USatriana Robert L · Belen, NMN4935AVucetic Miroslav · Coral Springs, FLN4936AAnderson Dennis G · Eagle River, AKN4936NSwett Alan · Panora, IAN4936TDakma LLC · Parma, OHN4937SRauch James A III · Cayce, SCN4937TSalsbery Enterprises Inc · Sharpsville, INN4939CBard Ralph M · Tullahoma, TNN4939YDavidson Dan F · Ozona, TXN4939ZStaheli Lee E · Kiana, AKN493CPCivil Air Patrol · Maxwell Afb, ALN493JLPhoenix Flyers Inc · Mesa, AZN4940ASims Charles A · Chugiak, AKN4940DAirborne One LLC · Kalispell, MTN4940NWray James R Jr · Brighton, CON4941FPaddock Levi · Springfield, ORN4942AChapman Peter E · Placerville, CAN4942DN4942d LLC · Greenfield, NHN4942UCenturion LLC · Bonney Lake, WAN4944DSelkirk Associates Inc · Wilmington, DE
Back to AD 84-10-01 R1