Skip to content

Registered aircraft · 54,019

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N18167Be Chara Niz Ar E · Columbia, MDBuilt 1972 · S/N 15073838 N1816CCalvert Tobin R · San Antonio, TXBuilt 1953 · S/N 25960 N1816FMalcom Scott O · Toledo, WABuilt 1965 · S/N 21058716 N1816JWakefield Aircraft LLC · Cooperstown, NDS/N 182-68574 N1816QS And E Airplane Company · Puyallup, WABuilt 1971 · S/N 177RG0216 N1816RArizona Game & Fish Dept · Phoenix, AZBuilt 1974 · S/N 18502531 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 N1817QJohnston Bernard D · Puyallup, WAFirst renewal noticeBuilt 1971 · S/N 177RG0217 N1817RLfg Properties LLC · Portage, MIS/N R18200571 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 N1818RSideline Services LLC · Pearland, TXBuilt 1978 · S/N R18200572 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 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 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 N181STWagontrainer LLC · Kalispell, MTBuilt 1954 · S/N 30997 N181TTWilson James · Bagwell, TXBuilt 1964 · S/N 17252385 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 N1820KBergstrom Aircraft Inc · Pasco, WABuilt 1975 · S/N 182-64092 N1820RBarkhimer James C · Iraan, TXBuilt 1974 · S/N 18502535

Back to AD 87-20-03 R2