Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N8201SMann Derek W · Burwell, NEBuilt 1965 · S/N 15061801 N8201ULerma Homero G · Mcallen, TXBuilt 1964 · S/N 17252101 N82029Sarason Jay A · Monte Vista, COBuilt 1946 · S/N 7AC-655 N8202AWeaver Savannah N · Fortson, GABuilt 1952 · S/N 25054 N8202F98x LLC · Caddo Mills, TXBuilt 1966 · S/N 15064302 N8202LHorizon Flights Corp · Henderson, NVNon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 17256402 N8202SBell Tammy L · San Antonio, TXS/N 15061802 N8202UBudget Flyers · Shreveport, LABuilt 1964 · S/N 17252102 N8202XFerris Tyler S · Pompano Beach, FLFirst renewal noticeS/N 17248702 N82038Peder Alexander E · Kirkland, WAS/N 7AC-664 N8203AVista Aviation Services LLC · Boone, IABuilt 1952 · S/N 25055 N8204LJohnson Kathy L · Wellsburg, WVBuilt 1967 · S/N 17256404 N8204TChampion Anthony R · Troy, MOBuilt 1960 · S/N 17556904 N8204USchenck Paul · Glendale, CAS/N 17252104 N8204XWallace Howard C · Lompoc, CABuilt 1961 · S/N 17248704 N8205BHarrison Joseph T · Pensacola Beach, FLBuilt 1957 · S/N 36005 N8205FRegistered aircraftBuilt 1966 · S/N 15064305 N8205SMckay Christopher · Point Arena, CAS/N 15061805 N8205UDby Flights LLC · Pennock, MNBuilt 1964 · S/N 17252105 N82061Krynik Mitchell G · Granbury, TXBuilt 1946 · S/N 7AC-687 N8206AWalker Jack A · Klamath Falls, ORBuilt 1952 · S/N 25058 N8206LPratt Errol C · Fayetteville, GABuilt 1967 · S/N 17256406 N8206UShortridge Gary F · Dover, TNBuilt 1964 · S/N 17252106 N8207FChantry Terrell A · Lake Havasu City, AZFirst renewal noticeBuilt 1966 · S/N 15064307 N8207LAero Biz Development Group LLC · Washington, DCBuilt 1967 · S/N 17256407 N8208BWidincamp Steve F · Dahlonega, GABuilt 1957 · S/N 36008 N8208LMt Avi8or LLC · Sheridan, WYBuilt 1967 · S/N 17256408 N8208XCompass Kitty Hawk LLC · Winneconne, WIBuilt 1961 · S/N 17248708 N8209LAbel John R · Haslet, TXBuilt 1967 · S/N 17256409 N820CCKimbrel Martin E · Oakville, WAS/N 1 N820MPPrice Michael Wade · Elkton, VABuilt 1975 · S/N 15076861 N820NDonnelly Mitch L · Mcloud, OKBuilt 2021 · S/N 65-10867 N820SWeddle William H · Winston, NMBuilt 2009 · S/N 5148 N820STTwente Ron K · Saint Peters, MOBuilt 1976 · S/N 15078376 N82104Caulkins Howell V · Chico, CABuilt 1946 · S/N 7AC-730 N82106Morrison Lillian M · Port Townsend, WABuilt 1946 · S/N 7AC-732 N8210AArdmore Aviation LLC · Novelty, OHBuilt 1952 · S/N 25062 N8210BGibson-Craig-Carmichael Anita Yvonne · Blacksburg, VABuilt 1957 · S/N 36010 N8211BHayfield Technical Services LLC · Tahlequah, OKS/N 36011 N8211LWelch James J · Salisbury, NCBuilt 1967 · S/N 17256411 N82125J & D Services Inc · Wilmington, DEBuilt 1946 · S/N 7AC-751 N8212AScarboro Thomas E · North Pole, AKBuilt 1952 · S/N 25064 N8212BSeven Delta Whiskey Club · Brush Prairie, WABuilt 1957 · S/N 36012 N8212LVersaw Charles J · Center, COBuilt 1967 · S/N 17256412 N8212XMonahan Linda J · Groveland, CABuilt 1961 · S/N 17248712 N82134El Paso Flying Service LLC · El Paso, ILBuilt 1946 · S/N 7AC-760 N8213LTraining Planes LLC · Tampa, FLBuilt 1967 · S/N 17256413 N8213SMcilrath Paul J · Des Moines, IABuilt 1965 · S/N 15061813 N8213UJohnson Matthew K · Paducah, KYBuilt 1964 · S/N 17252113 N8214ARozycki Seth · Little Falls, MNBuilt 1952 · S/N 25066

Back to AD 94-05-05 R1