Skip to content

Registered aircraft · 22,430

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-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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:87-08-08-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.

N1714JFernandes Gary DBA · Clallam Bay, WABuilt 1968 · S/N 28-24126 N1716JNess Brian · Wasilla, AKBuilt 1968 · S/N 28-24128 N1716TStratus Business Development LLC · Nashua, NHBuilt 1970 · S/N 28-7125030 N171EPAzure Leasing LLC · Oakdale, PABuilt 1989 · S/N 2841209 N171GStockwell Donald C · Westport, MABuilt 1978 · S/N 32R-7885241 N171JBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1968 · S/N 28R-30756 N171PPiper Aircraft Inc · Vero Beach, FLS/N 28020291 N171TWRsj Aviation LLC · Winston Salem, NCBuilt 1984 · S/N 32R-8413019 N171WAKessenich Kimberly D · Montello, WIBuilt 1973 · S/N 287305592 N1720TLumi Wings Corp · Goodyear, AZBuilt 1970 · S/N 28-7125033 N1722JDonah Thomas J · Plattsburgh, NYBuilt 1968 · S/N 28-24134 N1723HCo-Operative Cross Roads Flying Club · Albuquerque, NMBuilt 1977 · S/N 32R-7780187 N1724JKeeven Diana F · Hawk Point, MOBuilt 1968 · S/N 28-24136 N1725JNewton Mitchell W Sr · Huffman, TXFirst renewal noticeBuilt 1968 · S/N 28-24137 N1725TCarrell William G · Pittsburgh, PABuilt 1970 · S/N 28-7125036 N17286Pride Terence E · Columbia, TNS/N 32-40899 N1728HTn Millworks LLC · Mt Juliet, TNS/N 28-7716047 N1728JHogan Thomas A · Fairfield, OHS/N 28-24140 N172NDBlue Max Aero LLC · Miles City, MTBuilt 1988 · S/N 2837007 N1731JRiverside Exteriors Inc · Post Falls, IDBuilt 1968 · S/N 28-24144 N17324Macair Aviation LLC · Xenia, OHBuilt 1979 · S/N 287916050 N1732JWyatt Roger G · Midlothian, VAS/N 28-24145 N1732TGlasgow Construction Company Inc · Guin, ALBuilt 1971 · S/N 28-7125418 N1733JProkop Gregory P · Cambridge, MNS/N 28-24147 N1734HIndian Hills Community College · Ottumwa, IABuilt 1977 · S/N 28-7716048 N1734TTaylor David V · Clinton, NCBuilt 1970 · S/N 28-7125050 N1736TN1736t LLC · Lake Point, UTBuilt 1970 · S/N 28-7125052 N1737ARegistration Pending · Bulverde, TXRegistration pendingBuilt 1964 · S/N 28-1540 N1737TN1737t LLC · West Palm Beach, FLBuilt 1970 · S/N 28-7125054 N1738JPiper 38j LLC · Buckeye, AZBuilt 1968 · S/N 28-24153 N1738TClinton 83 Aviation LLC · La Place, LAS/N 28-7125055 N1739JSahli Theodore E · Costa Mesa, CABuilt 1968 · S/N 28-24154 N1739TWatkins Felton III · Meridian, MSBuilt 1970 · S/N 28-7125056 N173MMitchell Jonathan L · Poteau, OKBuilt 1981 · S/N 32R-8113087 N173SNWilliams Hoffman Alexander M · Downers Grove, ILBuilt 1967 · S/N 32-912 N1741JReynolds David Hays J · Ariton, ALS/N 28-24157 N1743HN1743h LLC · Yorktown, VAS/N 28-7790337 N1743JRomualdi Giovanni · Torrance, CABuilt 1968 · S/N 28-24159 N1745TStoffer Aviation LLC · Marion, INBuilt 1970 · S/N 28-7125063 N1746H1746h LLC · La Mirada, CAS/N 28R-7737011 N1746THessing Dale C · Eagle, IDBuilt 1970 · S/N 28-7125064 N1747HRooks John S · Barrington, RIBuilt 1977 · S/N 28R-7703033 N1747JCromwell James A · Little Rock, ARBuilt 1968 · S/N 28-24165 N1747TErickson Carrian Brooke · Overland Park, KSBuilt 1970 · S/N 28-7125065 N1748JHaywood Aviation & Salvage LLC · Atlanta, TXBuilt 1968 · S/N 28-24167 N1748TBallard George M · Mchenry, ILBuilt 1970 · S/N 28-7125066 N1749TCollier Tony · Grayson, KYBuilt 1970 · S/N 28-7125067 N174CAVy Aeroventure LLC · Bloomfield Hills, MIBuilt 1994 · S/N 3213080 N174DCAire Services LLC · Barrigada, GUBuilt 1980 · S/N 28-8190085 N174FVy Holdings LLC · Scottsbluff, NES/N 28-854

Back to AD 87-08-08 R3