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.

N63882Jacobs John T · Littleton, COS/N 15416 N6388GGaller Frank G · Elysian, MNBuilt 1970 · S/N 15071888 N6389GHagen Alfred · Bensalem, PABuilt 1970 · S/N 15071889 N638LSClark Billy B · Pride, LABuilt 2008 · S/N 650-105 N6390ERyan Michael P · Melrose, IAFirst renewal noticeBuilt 1959 · S/N 46490 N6390SStraub Aircraft Holdings LLC · Overland Park, KSBuilt 1967 · S/N 15067190 N6393EBrewster Richard D · Bellvue, COBuilt 1959 · S/N 46493 N6393HMorgan Jeffrey B · Edgewater, FLBuilt 1946 · S/N 19583 N6393XMccarney Thomas R · Box Elder, SDBuilt 2000 · S/N 010 N63950Vest Dennis · Reno, NVBuilt 1999 · S/N 510 N6395EStott David L · Wasilla, AKBuilt 1959 · S/N 46495 N6398EMetter John R · Litchfield, OHBuilt 1959 · S/N 46498 N6398GCrowned Eagle Aviation LLC · South Saint Paul, MNBuilt 1970 · S/N 150-71898 N6399EMountain House LLC · Clear Lake, IABuilt 1959 · S/N 46499 N639LSRichardson Jesse D · Fort Wayne, INBuilt 2009 · S/N 650-107 N63CZCoan Eli P · Goldsboro, NCBuilt 1963 · S/N 15060070 N63GN63gn LLC · Helena, MTBuilt 2011 · S/N TX-1032 N63KGCleveland Gary W · Independence, ORBuilt 1962 · S/N 17250000 N63NNWild Daniel · Manhattan, KSBuilt 2024 · S/N 1 N6400BHowes Frank E · Macomb, MIBuilt 1956 · S/N 29600 N6400DDanker Dale W · Inola, OKBuilt 1946 · S/N 8026 N6400FAirplanes Unlimited LLC · Jackson, TNBuilt 1966 · S/N 15063000 N6400GCollier James S · Jesup, GABuilt 1970 · S/N 15071900 N6400TCampbell Larry L · Fort Mill, SCBuilt 1959 · S/N 17800 N6401EReynolds Richard E · Trumansburg, NYBuilt 1959 · S/N 46501 N6401FPfd Aviation LLC · Sheridan, WYBuilt 1966 · S/N 15063001 N6402EWichman Scott A · Lewistown, MTS/N 46502 N6402FMaier Andrew J · Barnesville, MNBuilt 1965 · S/N 15063002 N6403DRoslanksky James J · Tehachapi, CAS/N 220 N6403FFertile Flying Club Inc · Fertile, MNBuilt 1966 · S/N 15063003 N6403GKassel Willard C · Sicily Island, LAS/N 15071903 N6403HOtto Bryant C · Conway, ARBuilt 1946 · S/N 19705 N6403TSawicki Michael T · Midland, MIS/N 17803 N6404CWhiteside Donald J · Santa Cruz, CABuilt 1947 · S/N 7BCM-296 N6404GWarrior Aviation LLC · Prior Lake, MNBuilt 1970 · S/N 15071904 N6404MSturdevant Darin D · Newberg, ORBuilt 1946 · S/N 8591 N6404TWestrum Enterprises LLC · Norwalk, IABuilt 1959 · S/N 17804 N6405ERiggs Bradley A · Emporia, KSBuilt 1959 · S/N 46505 N6405GArmond Richard J · Thousand Oaks, CABuilt 1970 · S/N 15071905 N6405TBrunks Paul D · Peachtree City, GAS/N 17805 N6406BWojtacha Jacob M · Wasilla, AKBuilt 1956 · S/N 29606 N6406EOwczarek Przemyslaw J · Hampton Bays, NYBuilt 1959 · S/N 46506 N6406KWandell Daniel J · Murfreesboro, TNBuilt 1975 · S/N 15077687 N6407BMclean Diane A · Weirsdale, FLBuilt 1956 · S/N 29607 N6407EN6407e LLC · Hanover, MDBuilt 1959 · S/N 46507 N6407TKane Erik W · Mojave, CABuilt 1959 · S/N 17807 N6408EMorgan Lloyd J · Memphis, MOBuilt 1959 · S/N 46508 N6408KShowah Michael F · Scottsdale, AZS/N 15077688 N6408THowland Timothy A · Mankato, MNBuilt 1960 · S/N 17808 N6409EChehalis Skies Aircraft LLC · Chehalis, WABuilt 1959 · S/N 46509

Back to AD 94-05-05 R1