Skip to content

Registered aircraft · 20,483

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.

N3624UWilkinson Larry G · Henderson, NVBuilt 1963 · S/N 18255024 N3625CBurton Michael A · Chicago, ILBuilt 1978 · S/N R18200283 N3626CCowey Kevin M · Pittsburgh, PABuilt 1978 · S/N R18200284 N3626YNb Ag Solutions Inc · Manila, ARBuilt 1963 · S/N 21058126 N3627CWebb Brent · Safford, AZBuilt 1978 · S/N R18200285 N3627UStribling Tyron S · Lagrange, GABuilt 1963 · S/N 18255027 N3627YBarber Michael · Pagosa Springs, COS/N 21058127 N362KTOverstreet Investments Inc · Boonville, MOBuilt 2018 · S/N 18283043 N362KWFliteco Holdings LLC · Lewes, DES/N 18260338 N362MEDesmond James M · Oceanside, CABuilt 2000 · S/N 18280851 N362PC362 Papa Charlie LLC · Spokane, WABuilt 1972 · S/N 18261242 N3631CClark Mark R · Pullman, WABuilt 1954 · S/N 31129 N3631UBurden Richard M · Woodway, TXBuilt 1963 · S/N 18255031 N3633UBrasher Cecil V Jr · Jamestown, NCBuilt 1963 · S/N 18255033 N3635CMckinney Steve R · Hamersville, OHBuilt 1954 · S/N 31133 N36362Sale Reported · WitshireSale reported, pending cancellationBuilt 1955 · S/N 31691 N3636UVandeman Jack P · Norco, CABuilt 1963 · S/N 18255036 N3636YMorales Peter · Lake Worth, FLBuilt 1963 · S/N 21058136 N3637CThree Seven Charlie LLC · Camp Hill, PABuilt 1978 · S/N R18200288 N3639UWaltz Elizabeth · Grapevine, TXBuilt 1963 · S/N 18255039 N3639YMurphys Flying Service LLC · Quitman, GABuilt 1963 · S/N 21058139 N363CS3tr Aviation LLC · Longview, TXBuilt 2022 · S/N 18283163 N3640UMarkle Raymond J · Madawaska, MEBuilt 1963 · S/N 18255040 N3641CFeldmann D Joshua · Epworth, IABuilt 1978 · S/N R18200290 N3642CMcmahan Bryan · Gakona, AKBuilt 1954 · S/N 31140 N3642UPm Barrett Aviation LLC · Tucson, AZBuilt 1963 · S/N 18255042 N3643BCoffelt Kelly L · Bend, ORBuilt 1956 · S/N 32347 N3643CThompson Thomas S · Stoutsville, OHS/N 31141 N3643UN3643u Aviation LLC · Denver, COBuilt 1963 · S/N 18255043 N3644ULawrence Carl E · Boulder, COBuilt 1963 · S/N 18255044 N3645UHusaim John Steven · Hohenwald, TNBuilt 1963 · S/N 18255045 N3646UGarner Lynn · Preston, IDS/N 18255046 N3646YAerohawk Aviation Inc · Idaho Falls, IDBuilt 1963 · S/N 21058146 N3647CSmith Kristopher D · Wickenburg, AZBuilt 1954 · S/N 31145 N3647UAdams Verne Franklin · Madera, CABuilt 1963 · S/N 18255047 N3648UMerlin Aviation LLC · Grants Pass, ORBuilt 1963 · S/N 18255048 N3649CBayou Flight LLC · Parker, COBuilt 1954 · S/N 31147 N3649USteele Aerospace Service LLC · Tulsa, OKS/N 18255049 N364CMoore Charles K · Woodinville, WABuilt 1978 · S/N 18266262 N364MGCw Aviation LLC · Washta, IABuilt 1979 · S/N R18201246 N3650CTotty Michael N · Gainesville, MOBuilt 1954 · S/N 31148 N3651CHately William · Anchorage, AKBuilt 1978 · S/N R18200295 N3651UDeibel Adam · Flagstaff, AZS/N 18255051 N3652YMokhtari Rasoul · Nashville, TNBuilt 1963 · S/N 21058152 N3653CDomingquez Clara · Anchorage, AKBuilt 1954 · S/N 31151 N3653UMedeiros Germano Manuel · Caruthers, CABuilt 1963 · S/N 18255053 N3654CRose Hugh S · Fairbanks, AKBuilt 1954 · S/N 31152 N3655CViavant Toby S · Ester, AKBuilt 1954 · S/N 31153 N3655UBoggs Dennis E · Buffalo, WYBuilt 1963 · S/N 18255055 N3656UMccarty Troy Allen · New Plymouth, IDBuilt 1963 · S/N 18255056

Back to AD 84-10-01 R1