AD 84-10-01 R1
Registered aircraft · 20,486
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.
N157RDBoman & Kemp Lc · Ogden, UTN157STogo Aviation Services LLC · Palmer, AKN157SMHumphreys James F · Charleston, WVN157ZZRegistered aircraftN1581CFitzgerald Kenneth J · Millwood, WAN1581DChippewa Aero LLC · Montevideo, MNN1584CHaakenson John R · Sterling, AKN1585CHamilton Mark W · Durango, CON1586DZucchero David M · Stanwood, WAN1587MSkywagons.Com LLC · Placerville, CAN1587UGrant Aviation Inc · Anchorage, AKN158CPCivil Air Patrol · Maxwell Afb, ALN158CWMcdonald John C · Hallsville, TXN158DNiehaus James O · Erie, CON158FCDept Of Agriculture & Consumer Services · Tallahassee, FLN158JRCollins Stephen Neil · Clancy, MTN158PAndry Holdings LLC · Missoula, MTN1591DBrewer George F II · Colorado Springs, CON1591FBaer Monte Wayne · Ronan, MTN1592CPulver Douglas A · Kenockee, MIN1592FReynolds Frederick A · Pilot Point, AKN1592MDumais Robert J · Tilton, NHN1593CPeacock Richard M · Swansboro, NCN1594CFlyrs Field · Anchorage, AKN1595FVertical Horizon Aviation LLC · Sandown, NHN1595UJoiner Aviation LLC · Vinemont, ALN1596CFennell Kenneth J · Palmer, AKN1596MKret Geoffrey W · Godley, TXN1597MDodson International Parts Inc · Rantoul, KSN1598MZigler James B · Big Lake, MNN159CPCivil Air Patrol · Maxwell Afb, ALN159DRPiedmont Flight Inc · Winston Salem, NCN159FCDept Of Agriculture & Consumer Services · Tallahassee, FLN15APIndy Air Sales LLC · Anderson, INN15AZHopkins Todd · Russellville, INN15BFMayes Richard A · Bend, ORN15BPTidmore Argie D · Pottsville, PAN15DACamborne USA LLC · Collierville, TNN15MLN15ml LLC · Cresskill, NJN15MVAir Bellers Inc · Sunnyvale, CAN15MWZeezee LLC · Phoenix, AZN15PAFlight Dynamics LLC · De Leon Springs, FLN15RSCalvert Gregory E · Essex, MDN15SZZurcher Susan R · Hampshire, ILN15TBEast West Helicopter Inc · Batesville, INN15USFlypower Inc · Fort Lauderdale, FLN15WGSwirk Rhonda L · Center Conway, NHN15ZFRegistration Pending · Swan Valley, IDRegistration pendingN1600XLd&B LLC · Show Low, AZN1601CRoss Dale · Washtucna, WA
Back to AD 84-10-01 R1