Registered aircraft · 81,733

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

N420TCBowling Green Flight Center LLC · Bowling Green, OHBuilt 1999 · S/N 2843220 N420URcs Services LLC · California, MDBuilt 1997 · S/N 17280120 N420VHodges Mcneill Jr · Andersonville, GABuilt 2010 · S/N RD 001 N420WABlue Yonder Enterprises LLC · Los Altos, CABuilt 2017 · S/N 18283027 N4210HGage Ricky Duane · Lewiston, IDBuilt 1948 · S/N 14-13 N4210JPlamondon Steven J · Lake Leelanau, MIBuilt 1966 · S/N 28-22556 N4210QKoehn Jerome D · Fairview, OKBuilt 1971 · S/N 17260110 N4210ZMccarthy Gary W · Chugiak, AKBuilt 1966 · S/N 18-8429 N42111Blanchfield Christine Lizabeth · Devils Lake, NDBuilt 1974 · S/N 17264159 N42117Sturdivant Marshall J · Ellijay, GABuilt 1974 · S/N 17264160 N42118Walsh Air LLC · Live Oak, FLBuilt 1976 · S/N 177RG1088 N4211HRn Roofing LLC · Brandon, MSS/N 24-0662 N4211J11j Inc · Fort Lauderdale, FLBuilt 1966 · S/N 28-22558 N4211MMccartan Gary M · Pocahontas, IABuilt 1947 · S/N 12-3106 N4211NTaylor Dale W · Cape Fair, MOBuilt 1947 · S/N 13682 N4211QJwmp Air Inc · East Moriches, NYBuilt 1971 · S/N 17260111 N4211XClyde A Russell · Redlands, CABuilt 1971 · S/N 5211 N42126Zrelak Patrick · Apple Valley, CABuilt 1974 · S/N 17264162 N4212AEast West Aviation Club · DuffelS/N 32R-7885198 N4212HG And H Aviation · Louisville, KYBuilt 1978 · S/N 24-0663 N4212MMiller Taylor Robert Mamouney · North Bend, ORBuilt 1947 · S/N 12-3107 N4212TAci Medical Management Inc · San Marcos, CABuilt 1971 · S/N 28-7205099 N42138Cape May Aerial Advertising LLC · Rio Grande, NJS/N 14364 N4213HWiese Ryan Mark · Eagle River, AKBuilt 1948 · S/N 14-16 N4213MNatale William F · Saratoga Springs, NYBuilt 1947 · S/N 12-3108 N4213PLohse Teal K · Cordova, AKBuilt 1981 · S/N 2 N4213QFogarty Aviation Inc · Wasilla, AKBuilt 1971 · S/N 17260113 N4213TMallard Aviation LLC · Manchester, NHBuilt 1971 · S/N 28-7205100 N4213YFandrich Edward I · Payson, AZS/N 341-77 N4214HGranger Andrew J · Denver, COS/N 14-101 N4214MLawler Helicopter Leasing LLC · Rochester, MIBuilt 2009 · S/N 2008 N4214QMms Aircraft Leasing LLC · Williamsburg, VABuilt 1971 · S/N 17260114 N4214YAngran Nate J · Albia, IABuilt 1977 · S/N 1199-77 N4215HDavis John N · Port Alsworth, AKBuilt 1948 · S/N 14-18 N4215TBaker Michael D · Berlin, PABuilt 1971 · S/N 32-7200011 N4215YCg Air LLC · Mason City, IABuilt 1977 · S/N 968-77 N42161Registered aircraftS/N 28-7425312 N42166Snyder Jon · Charlotte, NCBuilt 1945 · S/N 14401 N42167Howarth Jason A · Lancaster, PABuilt 1974 · S/N 28-7415383 N42168Registration Pending · Denton, TXRegistration pendingBuilt 1974 · S/N 28-7415384 N4216TExtreme Metals LLC · El Dorado, ARBuilt 1971 · S/N 28-7205102 N4216YTusquittee Flyers Aero Club LLC · Hayesville, NCS/N 345-77 N4216ZGleason Egan · Valdez, AKBuilt 1966 · S/N 18-8437 N4217HBowser Dwight H · Anchorage, AKFirst renewal noticeBuilt 1948 · S/N 14-20 N4217JShuffler David · Kingman, AZBuilt 1966 · S/N 28-22565 N4217PInternational Air Services Inc Trustee · Carson City, NVS/N 23-1710 N4217TBentzen David A · Deer Park, WABuilt 1968 · S/N 28R-30975 N4217ZSchock Erik D · Wasilla, AKBuilt 1974 · S/N 18-7409043 N42183Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1945 · S/N 14425 N4218HGenna Aviation LLC · Newfield, NJBuilt 1978 · S/N 24-0665

Back to AD 81-18-04 R2