Registered aircraft · 54,019

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.

N14CPWheels Floats Skids And Skis LLC · Brooklyn, MIS/N 19721 N14CWThornwall Gregory C · Boonsboro, MDBuilt 1969 · S/N 15070656 N14GLMc Flying Club Inc · Lewistown, PABuilt 1966 · S/N 15063346 N14HKTrolinger John D · Kerrville, TXBuilt 1971 · S/N 15072566 N14JEN14je LLC · White Springs, FLBuilt 1975 · S/N 21060792 N14JMMckinstry Aviation LLC · Parker, COBuilt 1974 · S/N 18052475 N14KMRiver City Aero Club Inc · Columbus, GABuilt 1965 · S/N 17254062 N14LVSmetana Louis V III · Blair, NEBuilt 1970 · S/N 21059259 N14MDDaniel Development LLC · Durango, COBuilt 1962 · S/N 18254114 N14MRMarlin Aviation Flying Service LLC · West Palm Beach, FLBuilt 1972 · S/N 33701459 N14MTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N R18201227 N14NFStiles Terry D · King Salmon, AKBuilt 1968 · S/N 17256844 N14NNAms Aviation LLC · South Bend, INBuilt 1980 · S/N U20605374 N14PHHuman Lee · Mercer Island, WABuilt 1981 · S/N 18504323 N14PLByers Steven · San Diego, CABuilt 1966 · S/N 18051711 N14PNNefas Paul J · Sunland, CABuilt 1977 · S/N R1722602 N14SKHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283422 N14SWTriple R Ministries Inc · Crestview, FLBuilt 1974 · S/N 15075931 N14TXMcbride Robert W Jr · Mineola, TXBuilt 1963 · S/N 15060031 N14VCG5 LLC · Gallup, NMS/N 18264127 N14WAWright Brandon C · Cave City, KYBuilt 1966 · S/N 17254217 N14YYNorthwoods Air LLC · Orono, MEBuilt 1972 · S/N 18261390 N150Beam David · Sabina, OHBuilt 1969 · S/N 15071659 N15000Central District Aviation LLC · Seattle, WABuilt 1969 · S/N 17258075 N1500DMaxson Lee V · Mesa, AZBuilt 1951 · S/N 7722 N1500QShoaff Mark · Lehigh, FLBuilt 1971 · S/N 15072800 N1500TAguilar Honorio · Anna, TXBuilt 1965 · S/N 15061784 N1501MMeszler Christopher P · Spring Branch, TXBuilt 1975 · S/N 18264354 N1501VChinook Flying Club LLC · Chinook, MTBuilt 1976 · S/N R1722197 N1501YStreeter Christopher D · Vinita, OKBuilt 1962 · S/N 17249201 N1502DPaolucci Christopher J · North Olmsted, OHBuilt 1951 · S/N 7724 N1503UAmerican Jet Center Inc · Chino, CABuilt 1973 · S/N U20602228 N1504VCulman William A · Scotts Valley, CABuilt 1974 · S/N 17263633 N1505DPearce Cedric J · Chapel Hill, NCBuilt 1951 · S/N 7727 N1505QN1505q LLC · Brunswick, GAS/N 15072805 N1505TN1505t LLC · Tucson, AZBuilt 1966 · S/N P206-0212 N1506MBonn Steven · Hummelstown, PABuilt 1975 · S/N 18264356 N1506QDonald A D · Plano, TXBuilt 1971 · S/N 15072806 N1506VDeshon Loren · Friday Harbor, WABuilt 1974 · S/N 17263634 N1506YVaughn Jeffery Page · Shenandoah, VAS/N 17249206 N1507EGonzalez Moya Camilo Rafael · Fort Worth, TXBuilt 1978 · S/N 17271028 N1507QSafety In Motion Flight Center Inc · Puyallup, WABuilt 1971 · S/N 15072807 N1508CHutchings Alan J · Clewiston, FLBuilt 1953 · S/N 30208 N1508FHaley Wayne C · Okeechobee, FLBuilt 1964 · S/N 1850816 N1509CHammerquist Blake T · Benicia, CABuilt 1954 · S/N 30882 N1509MChalk 2 Inc · Apple Valley, CABuilt 1975 · S/N 18264357 N1509QBeavers David · Strasburg, COBuilt 1971 · S/N 15072809 N150AJChristianson Alan J · Washougal, WAS/N 15076664 N150AKCamp Ted A · Williamson, GAS/N 04940071 N150ANBachman Aviation LLC · Independence, IABuilt 1995 · S/N 04940074

Back to AD 87-20-03 R2