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.

N6119BHeart Mountain Aviation Services LLC · Knoxville, IABuilt 1957 · S/N 34119 N6119EBliss Richard F · Talladega, ALS/N 46219 N611BDClement Aviation Inc · Tea, SDS/N 17266692 N611CKovalesky James · Clayton, NCBuilt 1955 · S/N 26895 N611CAWilliams Todd A · Littleton, COBuilt 1977 · S/N 17269022 N611CCTjc Productions LLC · Ogden, UTBuilt 1979 · S/N 21063600 N611EAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1979 · S/N 17272471 N611GDufriend Daren P · Payson, AZS/N 33587 N611GGPence Edward R · Bakersfield, CABuilt 1979 · S/N R1723110 N611JFKeller Robert W · Racine, WIS/N 15077427 N611KHWolf Ronald T · Abbeville, LAS/N 15074824 N611PGWrightson Properties LLC · Ft Lauderdale, FLBuilt 1985 · S/N 21064911 N611SAAda Forestry Division · Malvern, ARBuilt 1976 · S/N 18265295 N611TMWest Michigan Skybirds Inc · Battle Creek, MIBuilt 1978 · S/N 21063037 N611WJDiamondtooling Inc · Wilmington, DEFirst renewal noticeBuilt 1975 · S/N 18264334 N611WSFreedom Flight Service LLC · Glendale, AZBuilt 1975 · S/N 21061134 N61205Lockhart Aero LLC · Austin, TXBuilt 1969 · S/N 15070886 N61206Hahlbohm Jeffrey S · Helena, MTS/N 15070887 N61207Desroches John · Scottsdale, AZS/N 15070888 N61208Cutone Ronald J · Old Saybrook, CTBuilt 1969 · S/N 15070889 N6120BSmith Richard D II · Luthersville, GAS/N 34120 N6120EFirestone Johnnie E · Portales, NMBuilt 1958 · S/N 46220 N6120FHickman Robert J · Canby, ORBuilt 1973 · S/N A1500421 N6120KArico James A · Lisbon, CTBuilt 1975 · S/N 15077535 N6120SLash Gary L · Round Rock, TXBuilt 1980 · S/N R18201618 N6120TBaker-Waite Kellie · Pawlet, VTBuilt 1964 · S/N 15060820 N61212Cole Lauren · Rockford, MIS/N 15070890 N61213Madrigal Francisco Javier · Newman, CABuilt 1969 · S/N 15070891 N61215Moody Bible Institute Of Chicago · Spokane Valley, WABuilt 1969 · S/N 15070892 N6121ETevik Michael A · Provo, UTS/N 46221 N6121FT & B Aero Enterprises Inc · Jacksonville, FLS/N 21059021 N6121GMckinney Christopher D · Statesville, NCBuilt 1969 · S/N 15071621 N6121TMcalilly Stephen L · Tupelo, MSBuilt 1982 · S/N R18201909 N6121VPugmire Marsh C · Saint Charles, IDBuilt 1980 · S/N 172RG0582 N61221Lang Christopher S · Genoa, NVBuilt 1969 · S/N 15070896 N61229Rivera Carlos A · Beach Park, ILBuilt 1969 · S/N 15070902 N6122ALambeth Air LLC · Sitka, AKS/N P21000867 N6122BBendickson Tim T · Priest Lake, IDBuilt 1957 · S/N 34122 N6122DBudde Bobby M Jr · San Jose, CAFirst renewal noticeBuilt 1979 · S/N 17272607 N6122EHolko Mickal A · Ravensdale, WABuilt 1958 · S/N 46222 N6122KKidd Robert Lee · Logan, UTBuilt 1975 · S/N 15077536 N6122NBernhard Andreas P F · Palm City, FLBuilt 1980 · S/N 18267792 N6122SBusiness Jet Managers Inc · Canton, MIBuilt 1980 · S/N R18201619 N6122TBach James S · Columbus, MTBuilt 1964 · S/N 15060822 N61231US Flight Academy International Inc DBA · Post, TXBuilt 1969 · S/N 15070904 N61232East Bay Trading Company LLC · Fairview, PABuilt 1969 · S/N 15070905 N61233Advanced Aviation LLC · Kapolei, HIBuilt 1969 · S/N 15070906 N61234Registered aircraftBuilt 1969 · S/N 15070907 N6123BNeal Aircraft Inc · Slaton, TXBuilt 1957 · S/N 34123 N6123FJws Aviation LLC · Edina, MNBuilt 1979 · S/N 17273153

Back to AD 87-20-03 R2