Skip to content

Registered aircraft · 3,961

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-21-02-R1') 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-21-02-R1') 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-21-02-R1')
    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-21-02-R1')
  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-21-02-R1')
  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-21-02-R1')
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.

N88555Iverson Douglas B · Sammamish, WABuilt 1981 · S/N 340A1262 N8856KHerrmann Alan J · Laguna Niguel, CABuilt 1981 · S/N 340A1264 N8857KBall Bearing Aviation LLC · Lowell, ARBuilt 1979 · S/N 340A0642 N88584Dallas Aero & Sales LLC · Poplar, MTBuilt 1979 · S/N 421C0642 N88604Trade Winds Aviation Holdings LLC · Lewes, DEBuilt 1978 · S/N 421C0604 N88606N88606 LLC · Ely, IAS/N 421C0649 N88646Eagle Air LLC · Garden Ridge, TXS/N 421C0630 N886BATerzo Richard E · Lake Zurich, ILBuilt 1981 · S/N 340A1269 N888BPXyz1234 LLC · Addison, TXBuilt 1979 · S/N 340A0737 N888EDGolden Eagle Express LLC · Dodge City, KSFirst renewal noticeBuilt 1973 · S/N 421B-0421 N888GPPt Air LLC · Madison, WIBuilt 1977 · S/N 310R1245 N888HCGolden Eagle 888hc LLC · Durham, CABuilt 1975 · S/N 421B0821 N888KPRunway 321 LLC · Hilton Head Island, SCBuilt 1977 · S/N 310R0918 N888MTSpelts Mark Warren Trustee · Chico, CABuilt 1979 · S/N 340A0763 N888NNorman James R · San Diego, CABuilt 1973 · S/N 340-0312 N888RCLeahy Kyle Bergen · Dallas, TXS/N 310I0067 N888VVAbaco Xpress LLC · West Palm Beach, FLBuilt 1973 · S/N 421B0550 N88JBJr Aviation LLC · Benton, KSBuilt 1969 · S/N 310P0174 N88KGSky West Aviation Inc Trustee · Albuquerque, NMS/N 340-0510 N88LTRyan M Kearbey Dental Corp · Oroville, CABuilt 1973 · S/N 310Q0835 N88PEFirst Winds LLC · Norfolk, NES/N 421C0851 N88RNInternational Air Services Inc Trustee · Carson City, NVS/N 310J-0077 N8904ZBuess Wayne R · Shirley, NYBuilt 1961 · S/N 310G0004 N8906ZGrismer Jeff Trustee · Hemet, CABuilt 1961 · S/N 310G0006 N8908ZLevin Robert G · Roseburg, ORBuilt 1961 · S/N 310G0008 N8909ZSumthin Limited · Wilmington, DEBuilt 1961 · S/N 310G-0009 N890CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1978 · S/N 402C0006 N890GRFly Compton Aeronautical Education Foundation · Compton, CAS/N 310H0130 N8910ZRazorhawk LLC · Birmingham, ALBuilt 1961 · S/N 310G0010 N8911ZSt Francis Aircraft LLC · Montrose, COBuilt 1961 · S/N 310G0011 N8923ZPanting Edwin A · Anchorage, AKBuilt 1962 · S/N 310G-0023 N8927ZEast Texas Aircraft Engines LLC · Palestine, TXBuilt 1962 · S/N 310G-0027 N8928ZSwanson Garret C · Valentine, NEBuilt 1962 · S/N 310G0028 N8930NReprop LLC 310 Series · Wilmington, DEBuilt 1977 · S/N 310R0986 N8932ZMclynn Matthew J · Green Valley, AZBuilt 1962 · S/N 310G-0032 N8934ZJeppson Edward Mckay Trustee · South Jordan, UTBuilt 1962 · S/N 310G-0034 N8939ZJenkins John C · Chocowinity, NCBuilt 1962 · S/N 310G-0039 N8941GHawks Eye View LLC · Roanoke, VAS/N 340A0327 N8941ZUplands Aviation Management LLC · Mineral Point, WIBuilt 1962 · S/N 310G-0041 N894JGMeasured Approach LLC · Wooster, OHBuilt 1972 · S/N 340-0098 N8956ZN8956z LLC · Brighton, COBuilt 1962 · S/N 310G-0056 N895ACTejas Cavu LLC · Wilmington, DEBuilt 1978 · S/N 340A0558 N8962ZMorris Russell L · Fort Myers, FLBuilt 1962 · S/N 310G-0062 N8965ZMathison John M · Del Norte, COBuilt 1962 · S/N 310G0065 N8976ZProsperity Properties Ltd · Southlake, TXBuilt 1962 · S/N 310G0076 N8979ZKimbrel Mark D · Rochester, WABuilt 1962 · S/N 310G0079 N8982ZEverett Dwight H · Pauma Valley, CABuilt 1962 · S/N 310G0082 N8986ZPremier Capital Enterprises LLC · Hurricane, UTS/N 310G0086 N8987ZRobinson Mark V · Vacaville, CABuilt 1962 · S/N 310G0087 N898EPMarcy Michael S · Farmington, NMBuilt 1973 · S/N 421B0429

Back to AD 87-21-02 R1