Skip to content

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

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

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.

N5885BGottlieb Kevin L · Anchorage, AKBuilt 1956 · S/N 33885 N5885TSale Reported · Cleveland, GASale reportedS/N 185-0785 N58860Rentz Jimmy L · Bainbridge, GABuilt 1973 · S/N 18262349 N58865Fairhill Properties LLC · Valley City, NDBuilt 1973 · S/N 18262354 N58866R And M Steel Company · Caldwell, IDBuilt 1973 · S/N 18262355 N5886BSchramm Craig O · Fenton, MIBuilt 1956 · S/N 33886 N58873Carman Steven W · Grass Valley, CABuilt 1973 · S/N 18262362 N58877Executive Flight LLC · Greenwood, MSBuilt 1973 · S/N 18262366 N5887BRedden Timothy Ray · Citrus Heights, CABuilt 1956 · S/N 33887 N5887FDe Leon Christopher · Donna, TXBuilt 1967 · S/N 21058887 N58882Coburn Shawn · Dos Palos, CABuilt 1973 · S/N 18262371 N58884Snider Aaron A · Ludington, MIBuilt 1973 · S/N 18262373 N58885Livengood John M · Prescott, AZBuilt 1973 · S/N 18262374 N58888Ducommun Robert C · New York, NYBuilt 1973 · S/N 18262377 N5888CCwf Enterprises Inc · Grove, OKS/N U20605888 N5889BLeitz Steven C · Cathlamet, WABuilt 1956 · S/N 33889 N588DCDynoair LLC · Watertown, SDBuilt 1998 · S/N 18280243 N58909Plantation Farms Inc · Wall, TXFirst renewal noticeBuilt 1973 · S/N 18262390 N5890BKilo Aviation LLC · East Peoria, ILBuilt 1956 · S/N 33890 N5891THutchison John N · Big Lake, AKBuilt 1964 · S/N 1850791 N58923Singh Jaspal · Sacramento, CABuilt 1973 · S/N 18262394 N58924Quicksilver Air Inc · Fairbanks, AKS/N 18262395 N58926Hawkeye Aviation Inc · Yakima, WABuilt 1973 · S/N 18262397 N5892THayden Daniel · North Pole, AKBuilt 1964 · S/N 185-0792 N58944Cassada Josh A · Charlevoix, MIBuilt 1973 · S/N 18262415 N58949M & M Aircraft LLC · Cresson, TXBuilt 1973 · S/N 18262420 N5894BFischer Alfred M DBA · Genoa City, WIS/N 33894 N58954Musheinesh Issa A · Bloomfield Hills, MIBuilt 1973 · S/N 18262424 N5895THeligray LLC · Kalispell, MTBuilt 1964 · S/N 185-0795 N58960Regan Ed · Torrance, CABuilt 1973 · S/N 18262428 N58961Monteith Andrew W · Lebanon, PABuilt 1973 · S/N 18262429 N58964Likens Tony G · Longville, MNBuilt 1973 · S/N 18262432 N58967Whatsup LLC · Mccomb, MSBuilt 1973 · S/N 18262435 N58976Pennington Tony D · Corpus Christi, TXBuilt 1973 · S/N 18262439 N5897CGot Wings LLC · Woodbury, NYBuilt 1973 · S/N 18262437 N5897ECoral Breeze Aviation LLC · Hinsdale, ILS/N 18268337 N58981Skloss Anthony W · Edinburg, TXBuilt 1973 · S/N 18262441 N58989Texas Wings In The Air II LLC · Santa Teresa, NMBuilt 1973 · S/N 18262442 N58994Aviation Trust Co LLC Trustee · Oklahoma City, OKS/N 18262444 N58998Coach Aviation LLC · Dover, DES/N 18262446 N58999United Indian Missions DBA · Tucson, AZBuilt 1973 · S/N 18262447 N5899BRi Skydiving Aircraft LLC · Middletown, RIBuilt 1956 · S/N 33899 N5899TBrignac Flying Service LLC · Columbus, MSBuilt 1965 · S/N 1850799 N589JSWings West Consulting LLC · Mesa, AZBuilt 1980 · S/N U20606384 N589RRock & Roe LLC · Corpus Christi, TXBuilt 1975 · S/N 18264115 N58BDBravan Aviation Inc · Fort Lauderdale, FLS/N 21062742 N58CCPittsburgh Marine Technologies · Eighty Four, PABuilt 1981 · S/N R18201729 N58CR7192 Locke Road LLC · Millington, TNBuilt 2005 · S/N 18281544 N58DJPtc Financial Inc · Wilmington, DEFirst renewal noticeBuilt 1980 · S/N 21063920 N58DWWilson Daniel J · Mount Vernon, OHBuilt 1979 · S/N 18267139

Back to AD 84-10-01 R1