Skip to content

Registered aircraft · 54,015

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.

N6608BTucker William C · Phoenix, AZBuilt 1979 · S/N 15283959 N6608DAmericus Flying Club Inc · Americus, GABuilt 1979 · S/N 17272895 N6608EMans David A · Spearman, TXBuilt 1959 · S/N 56108 N6608RBogovich Robert E · Clifton, TXBuilt 1979 · S/N 172RG0210 N6608XJancaterino Daniel · Hull, MAS/N 21057608 N66090Skyline Solutions Inc · Deland, FLBuilt 1983 · S/N 17275963 N66091Ftg Leasing LLC · Watkins, COBuilt 1982 · S/N 17275964 N66092Grinberg Dmitry · Austin, TXBuilt 1974 · S/N 15075827 N66093Ponderosa Land Surveys LLC · Lead, SDBuilt 1974 · S/N 15075828 N66094Nelson Harry L · Towner, NDBuilt 1974 · S/N 15075829 N66097Gaskin Greg · Lake Almanor, CABuilt 1983 · S/N 17275965 N66099Maddock Jay A · Sugar Grove, ILBuilt 1974 · S/N 15075832 N6609APelon Robert C · Chugiak, AKBuilt 1956 · S/N 28709 N6609CTailwinds 23 LLC · Plymouth, MIS/N 30157 N6609DCopperhead Environmental Consulting Inc · Paint Lick, KYBuilt 1979 · S/N 17272896 N6609EClark Andrew M · Bend, ORBuilt 1959 · S/N 56109 N6609FMcalexander William Dean · Conover, OHBuilt 1966 · S/N 15063209 N6609WKingsford Smith LLC · Tulsa, OKBuilt 1982 · S/N P21000804 N660MRWilson Process Instrumentation Calibrations Inc · Muskegon, MIS/N 18258984 N660SRAom Aircraft LLC · Orlando, FLBuilt 1968 · S/N 17701151 N660TAReinhardt Anthony C · Duchesne, UTBuilt 1970 · S/N 17259612 N66105Everett Stanley J · Cumming, GABuilt 1974 · S/N 15075838 N6610AAccurso Jacob · Siletz, ORBuilt 1956 · S/N 28710 N6610FCabala Nicholas C · Bay City, MIBuilt 1966 · S/N 15063210 N6610GThomas Charles L · Yankton, SDBuilt 1970 · S/N 15072110 N6610RSonday Terrance · Spring, TXBuilt 1984 · S/N U20606822 N6610XJason Bullard LLC · Star City, ARBuilt 1960 · S/N 21057610 N66110Krikorian Philip · Fresno, CABuilt 1974 · S/N 15075843 N66111Cutlass 661 LLC · Orange Park, FLBuilt 1983 · S/N 17275967 N66115Hayes Orris E · Betsy Layne, KYBuilt 1974 · S/N 15075846 N66118Segarra Jo Ann · Ponce, PRFirst renewal noticeBuilt 1974 · S/N 15075849 N66119Northwest Wings LLC · Hillsboro, ORBuilt 1974 · S/N 15075850 N6611DMoralli Joseph · Chico, CABuilt 1979 · S/N 17272898 N6611FMehsling Thomas C · Byers, COBuilt 1966 · S/N 15063211 N6611MUsda Forest Service Fepp · Columbia, SCBuilt 1975 · S/N 18263777 N6611XNelson Ann · Box Elder, SDBuilt 1963 · S/N 18254798 N66120Osten Albert M · Poughkeepsie, NYBuilt 1974 · S/N 15075851 N66127Gulley Cameron L · Eastland, TXBuilt 1974 · S/N 15075856 N66128Mcgowan Walter R · Gold Hill, ORS/N 18052918 N6612AMazac Kennith M · River Falls, WIBuilt 1956 · S/N 28712 N6612EReeser Michael C · Paige, TXBuilt 1959 · S/N 56112 N6612FG & M Holdings LLC · Cedar Rapids, IABuilt 1966 · S/N 15063212 N6612RCourtney David P · Reedsport, ORBuilt 1979 · S/N 172RG0214 N6612VEverman Terry Jay · Vassar, MIBuilt 1980 · S/N 172RG0781 N66134Jacobs Inc · Huntsville, ALBuilt 1974 · S/N 15075862 N66137Calvert John · Tybee Island, GABuilt 1975 · S/N 15075864 N6613H6613 H Ltd · Wilmington, DEBuilt 1975 · S/N 17265510 N6613NBarreto Manufacturing Inc · La Grande, ORBuilt 1981 · S/N 18504312 N6613XPeery Robert C · Burns, TNBuilt 1960 · S/N 21057613 N66140Whitehead Patrick D · Cross Junction, VABuilt 1974 · S/N 15075866

Back to AD 87-20-03 R2