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.

N621PWSkyten Flying Club Inc · Orefield, PABuilt 1976 · S/N 17702461 N621SJAirmax Internet LLC · Troutman, NCBuilt 1979 · S/N 18267372 N621WHerzog Daniel L · Clinton, MIS/N 17248576 N62209Christiansen Aviation LLC · Wilmington, DES/N 17275229 N6220EStoudt Kristen D · Derby, KSBuilt 1958 · S/N 46320 N6220FHeberle David B · Castroville, TXBuilt 1965 · S/N 337-0220 N6220GDuncan Paul J · Bartlett, TNBuilt 1970 · S/N 15071720 N6220KKasden Louis Jr · San Diego, CABuilt 1975 · S/N 15077595 N6220NSchmidt Paul D · Derby, KSBuilt 1980 · S/N 18267803 N6220TStorey Erik A · Fillmore, CABuilt 1964 · S/N 15060920 N62217Wieken Peter J · Mount Joy, PABuilt 1968 · S/N R1720085 N62218Above The Clouds Aviation LLC · Middletown, DEBuilt 1981 · S/N 17275230 N6221AFlight Level Avionics & Maintenance Services LLC · Milton, FLBuilt 1956 · S/N 33021 N6221BJulius Kaleb · Mesa, COBuilt 1979 · S/N 15283909 N6221EAllgeier David G Jr · Taylorsville, KYBuilt 1958 · S/N 46321 N6221KWilson Steven J · Elkton, KYS/N 15077596 N6222AAir Charter · Ottawa, ILBuilt 1956 · S/N 33022 N6222EAlexander Tom · Alamogordo, NMBuilt 1959 · S/N 46322 N6222FPhotos Unlimited · Rancho Cordova, CABuilt 1975 · S/N 18264128 N6222GCosgrove Coleman · Juneau, AKBuilt 1970 · S/N 15071722 N6222RBarge And Associates Inc · Houston, TXBuilt 1965 · S/N 15061522 N6223BSpirek Aaron M · Henderson, NVBuilt 1978 · S/N 21062712 N6223GGulasy Teresa L · Tulsa, OKBuilt 1970 · S/N 15071723 N6223RBroadwell Eric · Woodstock, GABuilt 1965 · S/N 15061523 N6223SKlingele Beth A · Wapato, WABuilt 1967 · S/N 15067023 N6223VAxis Aviation LLC · Bloomingdale, GABuilt 1980 · S/N 172RG0593 N62244Christiansen Aviation LLC · Wilmington, DES/N 17275234 N6224AAviation Of North Florida LLC · Jacksonville, FLS/N 33024 N6224FMerrill James · Bigfork, MTBuilt 1975 · S/N 18264130 N6225AMilpower Inc · Nampa, IDBuilt 1956 · S/N 33025 N6225QElkinton Dusty Lee · Moundville, MOBuilt 1955 · S/N 31957 N6225RHartman Michael F · Montclair, CABuilt 1979 · S/N 172RG0122 N6225TMohnacky Robert A · Roscoe, ILBuilt 1964 · S/N 15060925 N6226Lewis Jay C · Spanaway, WABuilt 1967 · S/N R172-0227 N62266Skylens LLC · Hammond, LAS/N 17275239 N6226ADaggett Aviation Inc · Daggett, CABuilt 1956 · S/N 33026 N6226FLone Creek Ranch LLC · Williston, NDBuilt 1975 · S/N 18264131 N6226KBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 1975 · S/N 15077599 N6226RHamman Baron L · Dallas, TXS/N 15061526 N6227AAllur Air LLC · Minnetrista, MNBuilt 1956 · S/N 33027 N6227FAlund Timothy · Watervliet, NYBuilt 1975 · S/N 18264132 N6227KBuchman Jeffery · Bushnell, FLBuilt 1975 · S/N 15077600 N6227RMidwestern Soaring Assoc · Peculiar, MOBuilt 1965 · S/N 15061527 N6227TCarpenter Cattle Co Inc · Brewster, KSBuilt 1983 · S/N R18201944 N6227YWest Brook Group Inc · Pleasant Hill, IABuilt 1981 · S/N 21064301 N62281Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275242 N62283Flight School Of Gwinnett Inc · Lawrenceville, GAS/N 17275244 N62287Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17275247 N6228FLynch Kent · Edwards, ILBuilt 1965 · S/N 337-0228 N6228KSunset Leasing Inc · Sarasota, FLBuilt 1980 · S/N 17274175

Back to AD 87-20-03 R2