Registered aircraft · 5,086

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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.

N5963YS And S Aviation Consulting · Hampshire, ILBuilt 1966 · S/N 27-3132 N59681Aircraft Montana LLC · Helena, MTBuilt 1977 · S/N 36-7760094 N5969VNiver Randall H · Potomac, ILBuilt 1977 · S/N 32R-7780384 N596LKcc Aero LLC · Guaynabo, PRBuilt 1977 · S/N 31-7712036 N5972YBm Aviation LLC · Vinton, VABuilt 1966 · S/N 27-3143 N59752Visionaire Enterprises LLC · Statesville, NCBuilt 1975 · S/N 31-7612010 N59764Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1975 · S/N 31-7652037 N5977YRed State LLC · Daytona Beach, FLBuilt 1966 · S/N 27-3148 N59809Lou Dell Aviation LLC · Simpsonville, SCBuilt 1976 · S/N 31-7612037 N59826Air Arctic Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652077 N59829Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652081 N5982YDawkins Karlene A · Coral Springs, FLBuilt 1966 · S/N 27-3155 N59848Sanborn Map Co Inc · Colorado Springs, COBuilt 1976 · S/N 31-7612052 N59865Mccorkle Joseph P II · Tyronza, ARBuilt 1976 · S/N 31-7612065 N59867Cooper Keith L · Tabernash, COBuilt 1976 · S/N 31-7612068 N5986YBlackhawk Holding Corp · Wilmington, DEBuilt 1966 · S/N 27-3159 N59870Talkeetna Aero Services Inc · Anchorage, AKS/N 31-7612071 N598MAMartini Richard · North Haven, CTBuilt 1997 · S/N 3257009 N59906Alpha Whiskey 2 LLC · Brandon, MSBuilt 1974 · S/N 31-7552027 N5991VDebry Michael W Trustee · Palmdale, CABuilt 1977 · S/N 32R-7780386 N59936Kelly Kent R · Montgomery, ALBuilt 1975 · S/N 31-7512019 N59982Duck L'Ranch LLC DBA · Fort Lauderdale, FLBuilt 1975 · S/N 31-7552071 N59984Alpha Whiskey 1 LLC · Brandon, MSBuilt 1975 · S/N 31-7512042 N59987Wings As Eagles Mission Air Serv Inc · Oshkosh, WIBuilt 1975 · S/N 31-7552081 N599AHAvtran LLC · Clayton, MOBuilt 1984 · S/N 31-8452019 N59BBCooper Richard B · Fort Worth, TXBuilt 1981 · S/N 32-8124034 N59CARegistered aircraftBuilt 1994 · S/N 129 N59FCLamb Farms Inc · Oakfield, NYBuilt 1979 · S/N 31-7952117 N59GYChieftain N59gy LLC · Saint Augustine, FLBuilt 1977 · S/N 31-7852017 N59JCPegasus Air Charter LLC · Hartford, CTBuilt 1979 · S/N 31-7952181 N59TXThacker Jackie W · Hineston, LABuilt 1978 · S/N 32R-7887105 N5CQDlc Aviation LLC · Lakeland, GABuilt 1973 · S/N 31-7400977 N5HMEvans Hayward D · Saint Augustine, FLBuilt 1973 · S/N 27-7305041 N5LLInternational Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7812041 N5MHGould Ralph Harvey Jr · White Cloud, MIBuilt 1967 · S/N 32-40268 N5SWPrendergast Gene D · Willcox, AZBuilt 1978 · S/N 32R-7887150 N5YGSethjay LLC · Washington, DCBuilt 1995 · S/N 4636001 N60030Jmj Properties LLC · Atchison, KSBuilt 2006 · S/N T18208500 N6007VHauser Scott · Towanda, PABuilt 1971 · S/N 31024 N600AGBisignano Michael · Palm Coast, FLBuilt 1989 · S/N 4622053 N600AHCoastal Road Aviation LLC · Mukilteo, WABuilt 1969 · S/N 24-4863 N600AZDykema Carl F · Davie, FLBuilt 1969 · S/N 61-0022 N600CRSilver Throne Aviation LLC · Anchorage, AKBuilt 1989 · S/N 4622060 N600EDWeskalnies Michael · Jarrettsville, MDBuilt 1969 · S/N 60-0013 N600FABeaver Creek Adventures LLC · Bangor, MEBuilt 1975 · S/N 60-0246-101 N600JGWiltcher Christopher Alex · Gallatin, TNBuilt 1969 · S/N 32-40726 N600JKMcdonald Harry · Toccoa, GABuilt 1975 · S/N 60-0257-104 N600NJKralta Enterprises LLC · Sioux Falls, SDBuilt 1975 · S/N 60-0199-088 N600RSavanna Lakes LLC · Dover, DEBuilt 1969 · S/N 60-0018 N600RJRankin Richard · Germantown, TNBuilt 1979 · S/N 27-7954114

Back to AD 91-21-01 R1