Skip to content

Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

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 N331NCRise Aircraft 1 LLC · Tomball, TXBuilt 1984 · S/N 31P8414046 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 N3441QBluegrass Skyriders LLC · Vine Grove, KYBuilt 1977 · S/N 32-7740063 N344TXCline Lyndi · Royce City, TXBuilt 1966 · S/N 24-4478

Back to AD 84-19-03 R1