Skip to content

Registered aircraft · 72,001

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.

N136DCStreamline Aviation LLC · Battlefield, MOBuilt 1982 · S/N 136 N136DKReece Robert B · Halstead, KSBuilt 2003 · S/N 24654 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N136FSale Reported · Broomfield, COSale reportedBuilt 2001 · S/N 60300 N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171 N136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557 N136LMLge Flying Club · Canton, GABuilt 1975 · S/N 17265041 N136MMMiller Carl A · Vero Beach, FLBuilt 1993 · S/N 21718 N136RCCaldwell Richard A · Indn Hbr Bch, FLBuilt 2000 · S/N 24187 N136SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 10164 N136SMMartens Aerosports LLC · Garden City, NYBuilt 1998 · S/N 066 N136TRRv6a136tr LLC · Merrillville, INBuilt 2000 · S/N 34132 N136VPWartman Steven · Sandia Park, NMBuilt 1965 · S/N 28-21128 N136YJanoski David M · Fort Worth, TXBuilt 1960 · S/N 24-1991 N13701M-A-R-S Aircraft Leasing LLC · Williamsburg, VABuilt 1974 · S/N 17262953 N13703Kisser Carroll P · Alexandria, VABuilt 1974 · S/N 17262955 N1370ESprocket Aircraft Management LLC · Kennesaw, GABuilt 1978 · S/N 17270972 N1370UUnited States Air Force Aero Club · Usaf Academy, COBuilt 1976 · S/N 17267041 N13710Registered aircraftBuilt 1976 · S/N 17702456 N13715Wingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17262962 N13719Precious Metal Aviation LLC · Menomonee Falls, WIBuilt 1974 · S/N 17262966 N1371JSajko Gary · Chesapeake, VABuilt 1975 · S/N 371 N1371TSaviortree House Ministries · Coarsegold, CABuilt 1972 · S/N 28-7225485 N1371UStanton Sport Aviation · Stanton, MNBuilt 1976 · S/N 17267042 N13721Muth Robert F · Whitefish, MTBuilt 1974 · S/N 17262968 N13723Johnson Darwin E Jr Trustee · Hollywood, ALBuilt 1974 · S/N 17262970 N13725Moster Paul C · Morristown, NJBuilt 1974 · S/N 17262972 N13727Ofarrell Scott A · Sterling Heights, MIBuilt 1974 · S/N 17262973 N1372ECsa Aircraft Leasing LLC · Park City, UTS/N 17270974 N1372TGriffin Justin B · Hayesville, NCBuilt 1982 · S/N 83 N1372UFerguson Joseph L II · Fairmont, WVBuilt 1976 · S/N 17267043 N13731East Derrick A · Cullman, ALBuilt 1974 · S/N 17262977 N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462 N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N1373WGarces Manuel E · Jefferson, GABuilt 1963 · S/N 2654 N1373ZHoitt Edward D Jr · Deerfield, NHBuilt 1961 · S/N TD-479 N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465 N13741Rasmussen Tyler R · Independence, IAS/N 17262987 N13747Namund LLC · Roscommon, MIBuilt 1976 · S/N 17702466 N13748Ries Farms LLC · Hastings, MNS/N 17262989 N13749Son Of Jubal Ministry LLC · Bainbridge, GAS/N 17702467 N1374EKjeldgaard James K · Fremont, NEBuilt 1978 · S/N 17270976 N1374JE2a Distributors Inc · Monroe, GABuilt 1975 · S/N 374 N1374TLuckinbill LLC · Columbus, MTBuilt 1982 · S/N K-6 N1374USkydance Aviation LLC · Norfolk, VABuilt 1976 · S/N 17267045

Back to AD 87-10-06 R1