Skip to content

Registered aircraft · 40,472

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N3289QTrident Aircraft Leasing LLC · Easton, MDBuilt 1977 · S/N 28-7716146 N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401 N328ESisson J P · Litchfield, ILBuilt 2004 · S/N 20762 N32903Foxtail Aviation LLC · Orefield, PABuilt 1974 · S/N 28-7515271 N32904Sheidler Randy L · Gallipolis, OHBuilt 1974 · S/N 28-7515272 N32906Benson Brian R · Mauston, WIBuilt 1974 · S/N 28-7515273 N3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716147 N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493 N3292PCrosswindz Ranch LLC · Seminole, TXS/N 23-1242 N3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1967 · S/N 17700592 N3292ZAlbertson James M · Westville, FLBuilt 1959 · S/N 18-7229 N32932Gilbert Roy S · Mechanicsville, VABuilt 1974 · S/N 28-7515276 N3293BHuttunen Alice D Trustee · Wasilla, AKBuilt 1954 · S/N 18-3287 N3293FYe Xiaofeng · Los Gatos, CABuilt 1968 · S/N 680001 N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447 N3293VMckinney Brian · Lakeville, MNBuilt 1995 · S/N 80 N3293ZStraight And Leve Aeromedical LLC · Billings, MTS/N 18-7230 N32942Bent James L Jr DBA · Palatine Bridge, NYS/N 18-7231 N32947Alpe Holding LLC · Van Nuys, CABuilt 1974 · S/N 28-7515279 N3294TWolniansky Peter W · Ocean Grove, NJS/N 17700594 N32969Henry Robert K · Knoxville, TNBuilt 1974 · S/N 28-7515282 N32971Umbdenstock Jerry R · Thermopolis, WYBuilt 1974 · S/N 28-7505106 N3297TBurgdorf Dale A · Plano, TXBuilt 1967 · S/N 17700597 N32983Critz Sue Anne · El Paso, TXBuilt 1975 · S/N 28-7515283 N32988Blackman Jeremy Trustee · Memphis, TNBuilt 1974 · S/N 28-7515284 N3298PCross Albert B III · Salinas, CABuilt 1957 · S/N 23-1248 N3298T515 Aviation LLC · Dexter, IABuilt 1967 · S/N 17700598 N32990Trident Aircraft Leasing LLC · Easton, MDBuilt 1974 · S/N 28-7515285 N32993N32993 LLC · Provo, UTBuilt 1975 · S/N 28-7505108 N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N3299TSale Reported · Daytona Beach, FLSale reported, canceledBuilt 1967 · S/N 17700599 N329ACDean Henry C · Texarkana, TXBuilt 2001 · S/N 425-2000 N329GBN329gb LLC · Chattanooga, TNBuilt 1978 · S/N ME-45 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N329LTango Aviation Rentals LLC · Austin, TXBuilt 1967 · S/N 28-23574 N329PWalther Cameron R · Hallam, NEBuilt 1977 · S/N AA5A0329 N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512 N329RPPettis Loren K · Thomaston, GABuilt 2002 · S/N 24828 N329TKaney Jeffrey J · Naples, FLBuilt 1953 · S/N 18-2443 N32ADRobinson Helicopter Co · Torrance, CABuilt 1977 · S/N 0002 N32AHLai LLC · Flowood, MSBuilt 1982 · S/N 1268 N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32DHHighgate Aero Inc · Swanton, VTBuilt 2004 · S/N 4542004 N32DMHulme Thomas L · Fountain Hills, AZBuilt 1959 · S/N 23-1692 N32ERWolfe Bruce · Fredericksburg, TXBuilt 1978 · S/N AA5B0905 N32FNNoska Frank S IV · Wasilla, AKBuilt 2023 · S/N NOSEXP18-001 N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026 N32HHagaman John G Trustee · Alexandria, VABuilt 1967 · S/N 1512 N32HLSmith Elmer A · Rancho Cucamonga, CAS/N 176

Back to AD 80-04-03 R2