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.

N9574AHomeward Bound Enterprises LLC · Parker, COFirst renewal noticeS/N 18280824 N9574GKreiner Kurt · Rch Palos Vrd, CABuilt 1972 · S/N U20601774 N9574TMcclellan Fred L · Flint, MIBuilt 1960 · S/N 57374 N9574XFlying Nova LLC · Anchorage, AKS/N 21057874 N9575GGolden Eagle Outfitters · Delta Junction, AKFirst renewal noticeBuilt 1972 · S/N U20601775 N9575HBoca Aircraft Partners Inc · Coral Springs, FLBuilt 1981 · S/N 18267965 N95764Marc Inc · Bolton, MSBuilt 1978 · S/N 18266622 N95766Ongstad William · Harvey, NDBuilt 1978 · S/N 18266623 N9576TDe Vincenzo Chiara · Chicago, ILBuilt 1960 · S/N 57376 N9577XColumbia Asset Trust Corp Trustee · Wichita, KSS/N 18268560 N9577YShort Notice Inc · Pensacola, FLBuilt 1981 · S/N 21064552 N95785Elton Donald Robert · Kissimmee, FLS/N 18266630 N95789Katmai LLC · Mount Pleasant, TXBuilt 1978 · S/N 18266632 N9578XTvat LLC · Sun City, AZS/N 21057878 N9579EAdventist World Aviation · Wilson, NCBuilt 1984 · S/N 18268428 N9579XHayden Luke S · Yardley, PABuilt 1986 · S/N 18268561 N957CFBergdoll Barry L · Juneau, AKS/N 31623 N95801Abraham James · Johnson City, TNBuilt 1978 · S/N 18266634 N95802Aircraft Acquisitions Inc · Durham, NCBuilt 1978 · S/N 18266635 N95807Prostar Flight Services LLC · Bozeman, MTS/N 18266637 N95808Cape Cod Aero Club LLC · Falmouth, MABuilt 1978 · S/N 18266638 N9580BEds Flying Service Inc · Denton, MTBuilt 1957 · S/N 32877 N9580XNewman Michael Mcdermott II · Campo, CABuilt 1962 · S/N 21057880 N9581VMartin Northern Aviation LLC · Benton, ARBuilt 1998 · S/N 18280257 N95826Mountain Air Inc · Ducktown, TNBuilt 1978 · S/N 18266645 N9582MAmerican Aviation Inc · Woods Cross, UTBuilt 1981 · S/N 20700705 N95834Herschend James R · Ozark, MOBuilt 1978 · S/N 18266648 N9583MUsda Aphis Ppq · Edinburg, TXBuilt 1978 · S/N U20604552 N95841Para David B Trustee · Prescott, AZBuilt 1978 · S/N 18266652 N95848Makowski Maciej J · Nipomo, CABuilt 1978 · S/N 18266655 N9584QHoward Genetics Inc · Ardmore, OKBuilt 1998 · S/N 18280258 N9584TBruce Nicholson · Gallup, NMBuilt 1960 · S/N 57384 N95857A & M Airplane LLC · Grover Hill, OHBuilt 1978 · S/N 18266657 N95858Tucker Thomas O Jr · Austin, TXBuilt 1978 · S/N 18266658 N9585GBillmyer Services Inc · Friday Harbor, WABuilt 1972 · S/N U20601785 N95860Cumberland Air LLC · Stuart, VABuilt 1978 · S/N 18266659 N95863Shields Stephen T · Holly Springs, NCBuilt 1978 · S/N 18266662 N95865Registered aircraftBuilt 1978 · S/N 18266664 N95868Descco Design & Construction Inc · Fleetwood, PABuilt 1978 · S/N 18266665 N9586BAmidon Gary · Shady Cove, ORS/N 32883 N9586TRegistration Pending · Talent, ORRegistration pendingS/N 57386 N9586XMclenaghan Alvin N · Phoenix, AZBuilt 1962 · S/N 21057886 N95879P3 Aviation LLC · Austin, TXS/N 18266667 N9587XFulminare Aviation LLC · Ocala, FLBuilt 1962 · S/N 21057887 N9588BSmith Timothy E · Anchorage, AKBuilt 1957 · S/N 32885 N9588XHanson Roger D · Seattle, WABuilt 1962 · S/N 21057888 N95897Fisher Thomas F · Olalla, WABuilt 1978 · S/N 18266672 N9589GKinate Mike · Colorado Springs, COBuilt 1974 · S/N 18263405 N9589XFishel Thomas N Trustee · Reno, NVBuilt 1962 · S/N 21057889 N958JRReimel Joseph Jr · Salem, NJBuilt 1954 · S/N 30883

Back to AD 84-10-01 R1