AD 84-10-01 R1
Registered aircraft · 20,485
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.
N180JPMcmanamin John P · Anchorage, AKN180JSTakakjian Kyle · South Chatham, MAN180JTSproul Andrew W · Isabella, OKFirst renewal noticeN180JVBf Aviation LLC · Boulder, CON180JWStage One Associates LLC · Oxford, CTN180JZZehm John R · Breezy Point, MNN180KALofstedt Trever L · Scottsdale, AZN180KCThompson Robert M · Chandler, AZN180KEWerth Daniel · Anchorage, AKN180KKKrentsa Kenneth F · Stockbridge, MAFirst renewal noticeN180KMLone Eagle Aviation LLC · Wilmington, DEN180KNDavis Brian L · Phoenix, AZN180KPPerhus Kelly E · Kindred, NDN180KWBadger Brothers LLC · Houston, TXN180LLietz Terry · Peshastin, WAN180LCLincoln David M · Renton, WAN180LEEverhart Leon J III · Gould City, MIN180LFKurtz Garold D · Mound City, MON180LGBrisson Gisele A · Hollister, CAN180LHHubbert Larry · Belding, MIN180LJGwinn Donald · Mccall, IDN180LLPoplar Grove Airmotive Inc · Poplar Grove, ILN180LMRegistration Pending · Anchor Point, AKRegistration pendingN180LTTugaw Leslie T · Omak, WAN180LWNorthstar Adventures LLC · Port Alsworth, AKN180MBBowers Michael J · Chugiak, AKN180MEKelly Jeffrey Allen Sr · Washoe Valley, NVN180MHRegistered aircraftN180MJHoke Michael J · Highlands Ranch, CON180MKCui Jin · Glendora, CAN180MMWeber Randy J DBA · Homer, AKN180MSVelociraptor Aviation LLC · Toney, ALN180MTJ & D Flying LLC · Edmonds, WAN180MWGiles Richard E · Vass, NCN180NPoschwatta Jeffrey R · Kent, WAN180NAStrohl Aviation LLC · Devalls Bluff, ARN180NMReitman John M · Greenville, MEN180NTHuston Aaron C · Fox Island, WAN180NVM And G Brown LLC · Independence, ORN180NWStark James G · Cove, ORN180PCRisen LLC · Urbandale, IAN180PGRance Cory D · Moody, TXN180PHCornell David A · Palmer, AKN180PJBlackhurst John · Embarrass, MNN180PKChagnot Catherine J · Athens, OHN180PPLaughbon Ladd · Carson City, NVN180PRRuttley Enterprises Inc · Marrero, LAN180PTProcaccini Donald P Jr · Spring Hill, FLN180PWHerrold Alvin J III · Seward, NEN180PXFloerke Keith Joseph Jr · Taft, TX
Back to AD 84-10-01 R1