Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N1816YNicholas Thomas M II · Enid, OKBuilt 1962 · S/N 17249416 N18171Isaacson Arthur T · Hillsboro, MOS/N 15073840 N18173Bb Aero Works Ltd · Whitehouse, OHBuilt 1972 · S/N 15073842 N18174Connell William J · Woodinville, WABuilt 1976 · S/N 17702535 N18177Hoffman Rick W · Elk River, MNBuilt 1972 · S/N 15073846 N1817EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12169 N1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeBuilt 1971 · S/N 177RG0217 N1817XSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1965 · S/N 18255917 N1818Fulton Ricky L · Alex, OKS/N 18051551 N18180Woodward Aviation · Varnville, SCS/N 15073847 N18182Samaha Fadi · Point Roberts, WABuilt 1975 · S/N 18263913 N18189Jaam-A LLC · Matthews, NCBuilt 1972 · S/N 15073852 N1818AMaas Nancy C · Redding, CABuilt 1978 · S/N 18266532 N18197C150 Holdings LLC · Newark, DEBuilt 1972 · S/N 15073854 N18198Ohare Douglas K · Ainsworth, NEBuilt 1972 · S/N 15073855 N18199Forthman Scott Chance · Miami, FLBuilt 1972 · S/N 15073856 N1819CFischer Douglas J · Palermo, CAS/N 25963 N1819QSchmidt Mark · San Jose, CABuilt 1971 · S/N 177RG0219 N1819XGrant Steven T · Sellers, SCBuilt 1964 · S/N 18255919 N181ATNazario Rafael · Delray Beach, FLBuilt 1973 · S/N 18262686 N181CPEighty1 Aviation LLC · Canton, GABuilt 1964 · S/N 18255766 N181CSElkhorn Valley Trucks II LLC · Fremont, NEBuilt 2024 · S/N 18283280 N181DHWinkler Jeffery L · Brush, COBuilt 1964 · S/N 206-0220 N181EWoodhead Matthew E Trustee · Reno, NVBuilt 1979 · S/N 18267304 N181JBBarrows Grayson J · Mcminnville, ORBuilt 1963 · S/N 18051329 N181JMMccloy John S · Lakeland, FLBuilt 1953 · S/N 30145 N181MWCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1997 · S/N 17280181 N181NWitt Robert A · Anchorage, AKBuilt 1956 · S/N 32416 N181PKPacific Mission Aviation · Hagatna, GUFirst renewal noticeS/N U20606158 N181RBBeltz Richard R · Lehighton, PABuilt 1956 · S/N 32712 N181RCWheeler Douglas N Trustee · Santa Fe, NMBuilt 1978 · S/N 18052982 N181RDWoodcock Air LLC · Wilmington, DES/N 33701881 N181RPCain Jeffrey B · Godley, TXBuilt 1981 · S/N 18053180 N181SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 20608192 N181SCAlpha Charlie Aviation LLC · Oregon City, ORBuilt 2016 · S/N 172S11663 N181STWagontrainer LLC · Kalispell, MTBuilt 1954 · S/N 30997 N181TTWilson James · Bagwell, TXBuilt 1964 · S/N 17252385 N181TWTom Wood Aviation Inc · Fishers, INBuilt 2026 · S/N 172S13549 N181TXAddie-Air Inc · Bridgeport, TXBuilt 1981 · S/N U20606408 N181UKauffman Daniel C · Spring Grove, PABuilt 1981 · S/N 18268135 N181VVScriva Jennifer L · Sherwood, ARBuilt 1966 · S/N 15065010 N181XLHis Wings Air Service Inc · Hyder, AKBuilt 1966 · S/N 18051670 N18200Morristown Flying Service Inc · Talbott, TNBuilt 1972 · S/N 15073857 N18201Anderson William T · Pine Bluff, ARBuilt 1972 · S/N 15073858 N18202Flying Tomato Aviation LLC · Medina, OHBuilt 1972 · S/N 15073859 N18208Ivy James E · Alba, TXS/N 15073863 N1820EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12170 N1820KBergstrom Aircraft Inc · Pasco, WABuilt 1975 · S/N 182-64092 N1820RBarkhimer James C · Iraan, TXBuilt 1974 · S/N 18502535 N1820VAsp Kenneth · Thief River Falls, MNBuilt 1974 · S/N 17263762

Back to AD 79-10-14 R1