Skip to content

Registered aircraft · 6,916

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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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:71-13-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.

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 N3311GEdge Construction & Consulting Inc · Bement, ILBuilt 2007 · S/N 3257454 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 N333FRHofstetter Seth · Jacksonville, ORBuilt 2024 · S/N T18209131 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 N333PFDennis Bruce · Hesperus, COBuilt 2011 · S/N T18209027 N333PRGriffin Wings LLC · Lithia, FLBuilt 1973 · S/N 31-7305112 N333TCKaty Partnership Leasing LLC · Watertown, SDBuilt 2025 · S/N T18209166 N333WRRes Ipsa Aviation LLC · Atlanta, GABuilt 2022 · S/N 4636809 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 N334CCil Aviation LLC · Indianapolis, INBuilt 2016 · S/N 4636707 N334RPRegistration Pending · Seneca, SCRegistration pendingBuilt 1980 · S/N 31-8052071 N33556Midwest Diesel Inc · Beemer, NEBuilt 1975 · S/N 32-7540105 N335JWN335jw LLC · Hilton Head Island, SCBuilt 2019 · S/N T20609579 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 N336CPCivil Air Patrol · Montgomery, ALBuilt 2010 · S/N T18209012 N337CRElder Bruce W · Farmington, NMBuilt 2004 · S/N T18208259 N338SAGonzalez Jesse · Colorado Springs, COBuilt 1999 · S/N T20608041 N338WSWinsors Wings LLC · Rogersville, MOBuilt 2008 · S/N T20608828 N3393DFiscus Ronald E III · Anchorage, AKS/N 32-40656 N339CTPatel Niral G · Atlanta, GABuilt 1974 · S/N 27-7405350 N339MAAddie Holdings LLC · Jackson, TNBuilt 2016 · S/N 4636701 N33CALrb Aviation LLC · Catawba, NCBuilt 2019 · S/N 4636748 N33DNRegistered aircraftBuilt 1969 · S/N 24-4896 N33LMSkymax LLC · Stanford, KYBuilt 2018 · S/N 4636732 N33PGFoundation Of Wayne Community College Inc · Goldsboro, NCS/N 1782-5 N33PRWings To Carolina LLC · State College, PABuilt 1976 · S/N 32R-7780087

Back to AD 71-13-01 R1