Skip to content

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.

N32TEBlue Line Aviation LLC · Dunbar, NEBuilt 1999 · S/N 3257112 N33009Pamrus Inc · Zephyr Cove, NVS/N 32-7540080 N33068Crosby Michael W · Clearwater, FLBuilt 1975 · S/N 28-7510037 N33076Takagishi Hideto · San Jose, CABuilt 1975 · S/N 32-7540084 N33089Double Ll Enterprises LLC · Virginia Beach, VABuilt 1975 · S/N 32-7540086 N330AJHathaway David C · Helotes, TXBuilt 1989 · S/N 27-0017 N330MCWoolever Shane M · Sault Sainte Marie, MIBuilt 1978 · S/N 32R-7987072 N33133Balisier Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N 32-7540089 N33155Don George LLC · Orlando, FLBuilt 1975 · S/N 32-7540090 N332KCAdams William M · Southlake, TXBuilt 2003 · S/N 3257332 N33302Taffet Jay · New Orleans, LABuilt 1975 · S/N 32-7540092 N33307James Michael G · Dahlonega, GABuilt 1975 · S/N 32-7540093 N33368Triple Three Six Eight LLC · Alabaster, ALBuilt 1975 · S/N 32-7540096 N3338QGreenscapes Colorado Inc · Strasburg, COS/N 32-7740062 N333BPSt Lucie Aviation LLC · Fort Pierce, FLBuilt 1976 · S/N 32-7640124 N333CXFlying Bs LLC · Canby, ORBuilt 1967 · S/N 24-4720 N333EFTmak Inc · Visalia, CABuilt 1998 · S/N 3257053 N333EJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1975 · S/N 31-7652055 N333FSAerodrome LLC · Louisville, KYBuilt 1969 · S/N 27-4456 N333HGLow And Slow LLC · Brookline, NHBuilt 1969 · S/N 32-40627 N333KTSpringer Leasing LLC · Athens, GABuilt 1976 · S/N 32R-7680436 N333MKSmith Craig A · Kokomo, INBuilt 1993 · S/N 27-0172 N333PBBourne Hoppe & Associates LLC · Midland, MIBuilt 1975 · S/N 27-7654013 N333PRGriffin Wings LLC · Lithia, FLBuilt 1973 · S/N 31-7305112 N3340QHickey Aero Services LLC · White Hills, AZS/N 32R-7780307 N33411Pumpelly Thomas H · Dayton, OHFirst renewal noticeBuilt 1975 · S/N 32-7540098 N33496B A T S Aviation LLC · Long Island, KSBuilt 1975 · S/N 32-7540103 N334RPRegistration Pending · Seneca, SCRegistration pendingBuilt 1980 · S/N 31-8052071 N33556Midwest Diesel Inc · Beemer, NEBuilt 1975 · S/N 32-7540105 N33645Conner W Larry · Los Lunas, NMBuilt 1975 · S/N 32-7540108 N33669Ellsworth Donald · Beverly Hills, FLBuilt 1975 · S/N 32-7540110 N33699Burris D Rob Trustee · Tucson, AZBuilt 1975 · S/N 32-7540116 N337CRElder Bruce W · Farmington, NMBuilt 2004 · S/N T18208259 N338SAGonzalez Jesse · Colorado Springs, COBuilt 1999 · S/N T20608041 N3393DFiscus Ronald E III · Anchorage, AKS/N 32-40656 N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350 N33DNRegistered aircraftBuilt 1969 · S/N 24-4896 N33PGFoundation Of Wayne Community College Inc · Goldsboro, NCS/N 1782-5 N33PRWings To Carolina LLC · State College, PABuilt 1976 · S/N 32R-7780087 N33TLPaloma Uno LLC · Stuart, FLBuilt 1975 · S/N 31-7512043 N33UPAero Valley Properties LLC · Roanoke, TXBuilt 1961 · S/N 320-0078 N33WBSycamore Aviation Services LLC · Terre Haute, INBuilt 1978 · S/N 32R-7987056 N3406A406a Inc · Hollywood, FLS/N 3257044 N340HGVan Haitsma Kelly · Fort Worth, TXBuilt 1973 · S/N 340-0228 N340MASoar Aviation LLC · Rllng Hls Est, CABuilt 2001 · S/N 27-0314 N341BEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 27-0341 N341CACovenant Air LLC · Wilmington, DEBuilt 1979 · S/N 31-7952243 N341SW13:4 Aviation LLC · Brookfield, WIBuilt 1969 · S/N 32-40592 N342TSDaniels Law · Sherman Oaks, CABuilt 2001 · S/N T18208040 N343TCTwo Rivers Aircraft Managmenet LLC · Williamsburg, VABuilt 2004 · S/N T18208344

Back to AD 91-21-01 R1