Registered aircraft · 72,001

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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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-10-06-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.

N2309NEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1978 · S/N 0001 N2309PWielinga Pieter F · Hayes, VABuilt 1955 · S/N 22-2720 N2309QBorja Nicholas F · Freeburg, ILBuilt 1963 · S/N M-373 N230APOak View Capital LLC · Brookhaven, MSBuilt 1977 · S/N 297/24-09 N230ASN230as LLC · Wilmington, DEBuilt 1980 · S/N 31-8012062 N230CKKurella Charles James · Beaver Falls, PABuilt 1990 · S/N 001CK N230DHHarris Dwain L · Pickens, SCBuilt 2019 · S/N 309 N230DMGillespie Flying Services LLC · Trenton, SCBuilt 1997 · S/N 0325 N230EZMeyer Daniel B · Redding, CABuilt 2012 · S/N 462 N230FDConnolly Robert · Carmel, NYBuilt 2006 · S/N 1753 N230JCN230jc Inc Trustee · Wilmington, DEBuilt 1977 · S/N 27-7854011 N230MAParker-Omalley Corp · Chatham, NYBuilt 2004 · S/N 953-2004 N230MMLackey Matthew Allen · Peachtree City, GABuilt 1980 · S/N R18201529 N230PKGyger Keith J · Granbury, TXBuilt 1987 · S/N 200-041 N230RSAugust Aero LLC · Kalispell, MTS/N 023 N230RVEast Tennessee Aviation LLC · Mountain City, TNBuilt 1973 · S/N 17261598 N230SBSierra Bravo Partnership · Liberal, KSBuilt 2011 · S/N 001 N230SFWaters Robert · Albuquerque, NMS/N DMO 119 N230SWMartin Co · Tyrone, GABuilt 1971 · S/N 39-37 N230TDDickerson Timothy J · Woodlake, CABuilt 2020 · S/N 74551 N230WChandler Charles G · Luray, VABuilt 2003 · S/N 2230 N230WCKeiser John T · Santa Fe, NMS/N 010 N230XHHowell William J · Portola Valley, CAS/N 28-7425416 N2310JRegistration Pending · Aberdeen, SDRegistration pendingBuilt 1963 · S/N M-261 N2310QPeterson Kevin · Roseville, CABuilt 1963 · S/N M-374 N2311PCuller Stephen R · Winston Salem, NCBuilt 1955 · S/N 22-2722 N2311QHagy Thomas Lee · Abingdon, VABuilt 1963 · S/N M-375 N2311TAlanair LLC · Red Hook, NYBuilt 1971 · S/N 28R-7135197 N2311XGoodrich Joshua A · Webster, MNBuilt 1991 · S/N 1972 N2312LSumerau Robert L IV · Lexington, SCBuilt 1963 · S/N M-138 N2312NSale Reported · Maize, KSSale reportedBuilt 1991 · S/N 2018 N2312PMoran Thomas D · Orchard Park, NYBuilt 1955 · S/N 22-2723 N2312QMiller Kevin · Dover, DES/N M-376 N2312ZDfr LLC · Giltner, NEBuilt 1962 · S/N M-35 N23138Donaldson Docks Inc · Estherville, IAS/N 32R-8529010 N2313PWright Michael · Hurricane, UTS/N 22-2724 N2313ZT R Gemelli Holding Co LLC · Wilmington, DEBuilt 1979 · S/N 27-8054013 N2314EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271230 N2314JAce Aviation Seminars LLC · Armuchee, GABuilt 1963 · S/N M-377 N2314LSale Reported · Brunswick, OHSale reported, canceledBuilt 1963 · S/N M-140 N2315PFlood Joseph W · Franklinville, NJBuilt 1955 · S/N 22-2726 N2315TFaraone Nicholas Robert · Saint Petersburg, FLBuilt 1971 · S/N 28-7125499 N23162Dillon R Patterson Professional Services LLC · Prescott, AZBuilt 1968 · S/N 15068763 N2316LCarrigan Sean P · Slidell, LABuilt 1963 · S/N M-142 N2316TAircraft Solutions Group LLC · Englewood, COBuilt 1999 · S/N 17280694 N2316YWhitacre James P · Martinsburg, WVBuilt 1967 · S/N 17700116 N2317LAdamiak Jeffrey · Mount Laurel, NJBuilt 1963 · S/N M-143 N2317MHilton Head Flyers LLC · Liberty, SCBuilt 1977 · S/N 28-7816277 N2317TShirley Aviation LLC · Alexandria, VABuilt 1971 · S/N 28R-7135208 N2318JMcintyre Jon D · Fairbanks, AKBuilt 1979 · S/N 18-7909100

Back to AD 87-10-06 R1