Registered aircraft · 1,770

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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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:2018-03-03-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.

N2211QHill Jeffrey A · Bridgeport, WVBuilt 1968 · S/N 421A0011 N2214Q421 Partners · Delphi, INBuilt 1968 · S/N 421A0014 N2221QAviation Sales And Charter LLC · Dover, DEBuilt 1968 · S/N 421A0021 N222AXGraven Timothy G · Foristell, MOBuilt 1970 · S/N 414-0078 N222BJFlight Smith LLC · Orem, UTBuilt 1972 · S/N 414-0264 N222FGSkytravel LLC · Victoria, TXBuilt 1981 · S/N 414A0823 N222PLAnderas Per R · Green Bay, WIS/N 414A0521 N222PRFlying South LLC · Wilmington, DEBuilt 1973 · S/N 4140384 N222RMKelco LLC · Helena, MTBuilt 1971 · S/N 414-0168 N222SVEllsworth Jason W · Hamilton, MTS/N 414-0164 N2235QSparx Logistics USA Ltd · Charlotte, NCBuilt 1968 · S/N 421A0035 N2236QWoods Leland W · Klamath Falls, ORBuilt 1968 · S/N 421A0036 N223PBHyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0105 N226HPRegistration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N 414A0084 N228JHBuzzed Landing LLC · Ocean Springs, MSBuilt 1980 · S/N 421C-1006 N2293FTwo Mile High Mining LLC · Victor, COBuilt 1970 · S/N 414-0097 N22NRJefferson Aviation LLC · Seville, OHBuilt 1974 · S/N 4140497 N230MWGot Wings LLC · Woodbury, NYS/N 421C0671 N231JPQuest Air Inc · Cocoa, FLBuilt 1975 · S/N 414-0628 N232DTChancellor Shares LLC · Liberal, KSBuilt 1979 · S/N 414A0232 N233JHAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1977 · S/N 414A0009 N2345AAeolus Gold LLC · Wilmington, DEBuilt 1974 · S/N 421B0636 N2349SAjs Aviation LLC · Warroad, MNS/N 421C1209 N234DADestination Management LLC · Tulsa, OKBuilt 1971 · S/N 421B0122 N236ATN236at LLC · Miami, FLBuilt 1975 · S/N 414-0805 N236STOutdoor Metal Products LLC · Leighton, ALBuilt 1968 · S/N 401A0020 N237SMWestern Rivers Aircraft LLC · Paducah, KYBuilt 1976 · S/N 421C0237 N238FALetourmeau University · Longview, TXBuilt 1972 · S/N 421B0238 N239ELDingman Marine LLC · Orlando, FLBuilt 1975 · S/N 414-0808 N239JPTj Air Holdings Inc Trustee · Wilmington, DES/N 425-0016 N239SERiley Charles Sweeney · Highlands Ranch, COBuilt 1972 · S/N 421B0315 N23DTAlastrom Aviation LLC · Wilmington, DEBuilt 1975 · S/N 421B0852 N23GLAtlantic Assets Holding LLC · Dover, DEBuilt 1980 · S/N 414A0509 N23RHCajun Crimson Air LLC · Hoover, ALS/N 414A0258 N23RLCaljet Inc · Van Nuys, CABuilt 1981 · S/N 421C1094 N240RTAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1975 · S/N 421B0863 N241EWFort Carlos LLC · Fort Worth, TXBuilt 1978 · S/N 421C-0496 N241MWAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1975 · S/N 421C0030 N241TSGrey Matter Inc · Valley Springs, CAS/N 421B0110 N242HB2hb Airways LLC · Saint Louis, MOBuilt 1970 · S/N 421B0049 N245CRBlue Eagle Aviation LLC · Danville, CAS/N 4250063 N245JKSpruce Hill Leasing LLC · Hadley, MAS/N 414A0613 N245THigh Country Aero Ltd · Berthoud, COS/N 421C1104 N246BEOn Top Aviation LLC · North Las Vegas, NVBuilt 1976 · S/N 414-0841 N247GSHyannis Air Service Inc DBA · Hyannis, MABuilt 1982 · S/N 402C0637 N24GBSmith Loren · Great Falls, MTS/N 421C0287 N24SLSkye Tess Airlines LLC · Holmdel, NJBuilt 1980 · S/N 414A0610 N24TWCopper Rose LLC · Beaverton, ORBuilt 1981 · S/N 425-0132 N251JLGolden Eagle 421 LLC · Alsip, ILBuilt 1977 · S/N 421C0311 N251WWEbbert Thomas E DBA · Gary, INRegistration revokedBuilt 1967 · S/N 411-0251

Back to AD 2018-03-03 R1