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.

N7943BMoul Dale E · Boise, IDBuilt 1956 · S/N 29743 N7943FRegistered aircraftBuilt 1966 · S/N 15064043 N7943ZAlrubaiie Ihssan Robert · Fort Worth, TXBuilt 1963 · S/N 15060043 N79440Spatiumtech LLC · Madison, ALBuilt 1969 · S/N 17258089 N79442Friedmann David · San Diego, CABuilt 1969 · S/N 17258091 N79445Raniolo James · Jackson, WYBuilt 1969 · S/N 17258094 N79447Aroostook Aviation LLC · Millinocket, MEBuilt 1969 · S/N 17258096 N79448Thomas William B · Converse, LABuilt 1969 · S/N 17258097 N7944BHarms Steven Lee · Cedar Rapids, IABuilt 1957 · S/N 29744 N7944FBrown R Ed · Vandalia, ILS/N 15064044 N7944GBogardus Peter S · Gouverneur, NYBuilt 1970 · S/N 17259644 N7944ZFreeman J · Memphis, TNBuilt 1963 · S/N 15060044 N79450Smith Jeff C · Cincinnati, OHBuilt 1969 · S/N 17258099 N79453Zimmer James E · Corning, CABuilt 1969 · S/N 17258101 N79454Gavranovic Willie · Wharton, TXBuilt 1969 · S/N 17258102 N79459Resort Region Flying Club LLC · Kalispell, MTBuilt 1973 · S/N 18261821 N7945GWinger Matthew · Vail, AZS/N 17259645 N7945VN7945v LLC · Wilmington, DEBuilt 1967 · S/N 18051845 N79463Riley Richard G Jr · New Brighton, PABuilt 1973 · S/N 18261825 N79467Horschel Duane D · Springville, NYBuilt 1973 · S/N 18261828 N79468Whitmire Alan K · Canyon Lake, TXS/N 17258113 N7946BBrock Raymond Richard · Crescent, IAS/N 29746 N7946FPaul Paulson A · Kipnuk, AKBuilt 1966 · S/N 15064046 N7946GRegistration Pending · Beach City, TXRegistration pendingBuilt 1970 · S/N 17259646 N7946TWright Anthony · Tallahassee, FLS/N 56646 N7946UUpper Aircraft International LLC · Titusville, FLBuilt 1964 · S/N 17251946 N79472Frey Michael L III · Waco, TXBuilt 1969 · S/N 17258115 N79473Tnw Aviation LLC · Clinton, ARS/N 17258116 N79475Registered aircraftBuilt 1969 · S/N 17258118 N79477Shipley David L · Yates City, ILBuilt 1969 · S/N 17258120 N79478Fusano Lisa A · La Crescenta, CAS/N 17258121 N79479Larue Mark C · Leander, TXBuilt 1969 · S/N 17258122 N7947BJames Bobby F · Bloomfield, INBuilt 1957 · S/N 29747 N7947GStearman Field Aircraft Repair LLC · Benton, KSBuilt 1970 · S/N 17259647 N7947THarris Billy M · Waco, TXBuilt 1960 · S/N 56647 N7947ZBouchard Jamie Claude · Berwick, MES/N 15060047 N79482Matacotta Ernest A · Marietta, GABuilt 1969 · S/N 17258123 N79488Nevels Steven D · Merritt Island, FLBuilt 1969 · S/N 17258126 N79489Maisonet Gonzalez Hector W · Ocala, FLBuilt 1969 · S/N 17258127 N7948BGruber Barbara L · Centreville, VABuilt 1957 · S/N 29748 N7948TJolley Jonas D · Woodstock, GABuilt 1960 · S/N 56648 N7948ZRlh Montana LLC · Helena, MTBuilt 1963 · S/N 15060048 N79493Bounds Trucking LLC · Faison, NCS/N 17258130 N79498Gord James F · Sandwich, ILBuilt 1969 · S/N 17258132 N79499Johnson Benjamin M · Monroe, WIBuilt 1969 · S/N 17258133 N7949BHeffron Jacob L · Little Falls, MNS/N 29749 N7949FMaciol Michael W M D · Pelham, NYBuilt 1973 · S/N A1500452 N7949TMacleod Brian D · Maumee, OHBuilt 1960 · S/N 56649 N7949ZFlores Carah L · Perris, CABuilt 1963 · S/N 15060049 N794CTCarolina Custom Farm Equipment LLC · Wilson, NCBuilt 1965 · S/N 17252598

Back to AD 87-20-03 R2