Skip to content

Registered aircraft · 72,010

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N55216Huizar Victor · Albuquerque, NMBuilt 1973 · S/N 28-7305336 N55219Wilkinson Thomas W · Weyers Cave, VABuilt 1973 · S/N 28-7305337 N5521FMarc Inc · Brandon, MSFirst renewal noticeBuilt 1968 · S/N 28-24863 N5521JVanrider Jeffrey F · Wildwood, FLBuilt 1967 · S/N 32-958 N5521KBrowning Ricou R Jr · Melbourne, FLBuilt 1978 · S/N 386-78 N5521PSkyview Aviation Services Inc · Lakeland, FLBuilt 1958 · S/N 24-584 N5521UMiller Groom Marie T · Rockford, ILBuilt 1969 · S/N 28-26234 N55220Ishii Kanji · Brooklyn, NYBuilt 1973 · S/N 28R-7335195 N5522KHall Dean A · Hyattsville, MDBuilt 1965 · S/N 601 N5522QBarnhill Jerry D · Longville, LABuilt 1965 · S/N 614 N5522UAlbrecht Jeffrey N Trustee · Mount Horeb, WIBuilt 1969 · S/N 28-26237 N55236Bobnal LLC · Conway, SCBuilt 1981 · S/N 17275139 N5523FSirko Frederick S · Portage, INBuilt 1968 · S/N 28-24864 N5523PBens Motorworks Inc · Fullerton, CAS/N 24-586 N5523RPlett John · Anaconda, MTBuilt 1979 · S/N 172RG0069 N5523TCantrup Peter H · White Rock, NMBuilt 1982 · S/N R18201884 N5523UKlein Michael · Gilsum, NHBuilt 1969 · S/N 28-26238 N55240General Associated Products Inc · San Lorenzo, CABuilt 1973 · S/N 28-7325349 N55242Hills Holding · Newark, DEBuilt 1981 · S/N 17275142 N55244Wiechman Herbert · Boulder, COBuilt 1973 · S/N 28-7305340 N55246Kadena Aero Club · Apo, APBuilt 1981 · S/N 17275143 N55247Nordstrom Terry G · Scottsdale, AZBuilt 1973 · S/N 28R-7335199 N5524PSwarm Darryl J · Quincy, CABuilt 1958 · S/N 24-587 N5524QImwalle John N · Batavia, OHS/N 615 N5524SStellon Eugene A Jr · Burlington, CTBuilt 1980 · S/N R18201594 N5524WHoe David S · Stafford, VABuilt 1962 · S/N 28-614 N55250Colorado Aircraft Corp · Watkins, COBuilt 1981 · S/N 17275144 N55251Albatross Air Inc · Beaver, WVS/N 28-7305342 N55253Mccall Christopher J · Cocoa Beach, FLBuilt 1973 · S/N 28R-7335200 N55256Notam Aviation LLC · Portage Des Sioux, MOBuilt 1981 · S/N 17275146 N55259Heth Steven L · Westhope, NDBuilt 1973 · S/N 28-7325354 N5525FCashion Thomas A · Mastic, NYBuilt 1968 · S/N 28-24866 N5525JElliott James Richard · Florence, ALBuilt 1967 · S/N 32-984 N5525KMacomber Donald Conrad · Santa Ynez, CABuilt 1978 · S/N 1025-78 N5525WWells Nicholas · Dallas, TXBuilt 2002 · S/N 02-04-20 N55260Weich Ronald L · El Paso, TXBuilt 1973 · S/N 28-7305343 N55261Barton John S III · Gallatin, MOBuilt 1973 · S/N 28-7305344 N55263Fennell Donald H Jr · Hampstead, NCBuilt 1973 · S/N 28-7305345 N55264Ace Aircraft Leasing Inc · Nazareth, PABuilt 1981 · S/N 17275147 N5526FLandry Raymond L · Stark, NHBuilt 1968 · S/N 28-24867 N5526KOn-Site Aviation Inc · Hillsboro, NDBuilt 1978 · S/N 273-78 N5526MEz Breezy Fc LLC · San Diego, CAS/N 28-22539 N5526PWard County Irrigation District #1 · Barstow, TXS/N 24-589 N5526UPearl Wings LLC · Doylestown, OHBuilt 1969 · S/N 28-26242 N55270Mcconnell Jason A · Rose Hill, VABuilt 1973 · S/N 28-7325356 N55272Nienhuis Alvin Dale II · Brooksville, FLBuilt 1973 · S/N 28-7305348 N55273Jcb Aircraft Sales & Leasing Inc · Belle Mead, NJBuilt 1973 · S/N 28-7305349 N55275Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 28R-7335209 N55278Hackman Daniel W · Wimauma, FLBuilt 1973 · S/N 32-7300035 N55279West Georgia Air Services · Lagrange, GABuilt 1973 · S/N 34-7350195

Back to AD 87-10-06 R1