Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N2030KBuck William C Jr · Columbus, GABuilt 1978 · S/N E-1358 N20318Siegfried Thelma Trustee · Downers Grove, ILBuilt 1978 · S/N D-10173 N2031BHouser Roger · Luray, VABuilt 1978 · S/N E-1350 N2031KObrien Michael · South Orleans, MABuilt 1978 · S/N E-1352 N2031PBrooks Todd P · White Lake, MIBuilt 1978 · S/N E-1349 N2031RRons Air Service Inc · Two Buttes, COS/N CE-811 N2031ZJames Jeb S Dr · Bay City, TXBuilt 1978 · S/N TJ-165 N2032EOhio Air Partners LLC · Chardon, OHBuilt 1978 · S/N D-10170 N2033KAlcyone Trust Corp Trustee · Wichita, KSS/N U20601918 N2033LYoung Randolph F · Martinsburg, WVBuilt 1978 · S/N CE-808 N2033ZHogarth De La Plante John Rammacher · Snohomish, WABuilt 1978 · S/N CE-810 N2034JMd Aero LLC · Somerton, AZBuilt 1978 · S/N T18803339T N2035BLincoln David M · Punta Gorda, FLBuilt 1978 · S/N E-1359 N2035PHubert John P · Austin, TXBuilt 1978 · S/N D-10176 N2035RArizona Skyraiders LLC · Phoenix, AZBuilt 1978 · S/N E-1360 N2035WTitanium Aircraft LLC · Wilmington, DEBuilt 1965 · S/N TE-19 N2036PThat Fly Family LLC · Nicholls, GABuilt 1978 · S/N E-1364 N2036SLissie Flying Service · Lissie, TXBuilt 1975 · S/N 21061004 N2036ZCrescent Cross Aviation LLC · Ismay, MTBuilt 1978 · S/N E-1371 N2037ACrosswind Enterprises LLC · Box Elder, SDBuilt 1979 · S/N EA-3 N2037LSchryer Timothy B · Satsuma, ALBuilt 1978 · S/N CE-817 N2037NHoward Robert L · Jacksonville, NCBuilt 1978 · S/N CE-813 N2037QLemasters Steven C · Friendswood, TXBuilt 1978 · S/N E-1372 N2037SRubyco Inc Trustee · Wilmington, DEBuilt 1975 · S/N 21061005 N2037WGregs Crop Care Co · Wilbur, WABuilt 1965 · S/N D-7980 N2037ZCotten Galen M · Huntsville, TXS/N E-1370 N2038NAnken Frederick W · Holland Patent, NYBuilt 1978 · S/N CE-818 N2038SHatch Family Limited Partnership · Winslow, AZBuilt 1975 · S/N 21061006 N2038UWorld Aero Space Ltd · Henderson, NCBuilt 1978 · S/N D-10180 N2038VRusso Philip R · Tucson, AZBuilt 1978 · S/N E-1374 N2038XMilam Douglas Franklin · Red Creek, WVBuilt 1978 · S/N CE-819 N2039VOwen Michael · Port Charlotte, FLBuilt 1978 · S/N E-1375 N203BNCarlson Curt · Lake Havasu City, AZBuilt 1980 · S/N 310R2101 N203JLJfra LLC · Miami, FLBuilt 1981 · S/N 414A0670 N203PLHhj & Rbj Holdings LLC · Prattville, ALBuilt 1976 · S/N D-9898 N203RFRapid Flyers LLC · Rapid City, SDBuilt 2003 · S/N 0453 N2040ASchultz Philip W · Lancaster, CABuilt 1969 · S/N D-9024 N2040CWatson Anthony A · Midlothian, TXBuilt 1977 · S/N E-1135 N2040GFinal Forge LLC · Blountville, TNBuilt 1978 · S/N E-1380 N2040PTrb Aviation LLC · Fredericksburg, VABuilt 1978 · S/N D-10183 N2040UGillim Parvin D · Sheridan, INBuilt 1978 · S/N E-1381 N2040YCappel Eric H · Satellite Beach, FLBuilt 1978 · S/N D-10181 N2041PManke Brian W · Chesapeake, VABuilt 1978 · S/N CE-821 N2041WJimenez John D · San Antonio, TXS/N D-7982 N2041ZBlue Mesa LLC · Bend, ORBuilt 1978 · S/N TE-1144 N2042BHasemann James M · Gaithersburg, MDBuilt 1978 · S/N D-10185 N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983 N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010 N2043XWright Air Service Inc · Fairbanks, AKBuilt 1978 · S/N E-1387 N20444Cesafsky Allen A · Bend, ORBuilt 1978 · S/N CE-824

Back to AD 86-13-04 R3