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.

N2WMAir Resources Helicopters Inc · Salt Lake City, UTBuilt 1973 · S/N 31-7300975 N3000AWeeks Grp LLC · Summerland Key, FLBuilt 1978 · S/N 32R-7887287 N3000KRon Aire LLC · Preston, MNBuilt 1971 · S/N 32S-7140045 N30037N30037 LLC · Middletown, DEBuilt 1979 · S/N 32R-7887264 N30082Burnet Fredrick A · Monticello, UTBuilt 1978 · S/N 32R-7887268 N300AMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1976 · S/N 61P-0300-076 N300BXRegistered aircraftFirst renewal noticeBuilt 2000 · S/N 27-0300 N300HVBaja Flyers Corp Inc · San Diego, CABuilt 1971 · S/N 32-7140026 N300JPRedd James P Trustee · Eureka, CABuilt 1969 · S/N 32-40597 N300JRBeechcraft Heritage Museum · Tullahoma, TNBuilt 1968 · S/N TG70 N300LGSmith Foster F · Bishopville, SCBuilt 1980 · S/N 32-8024023 N300MPVictoria'S Wings LLC · Melbourne, FLBuilt 1975 · S/N 61P-0227-030 N300RASharper Media LLC · Irvine, CABuilt 1993 · S/N 27-0166 N300RMHiscall Enterprises Inc · Dickson, TNBuilt 1970 · S/N 32-7140003 N300VMDavis Laramie · Canyon, TXBuilt 1976 · S/N 32R-7780120 N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294 N30144Roberti Aviation Of Delaware Inc · Lighthouse Point, FLS/N 3257330 N30190N30190 LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7887272 N3019KColorado Air LLC · Colorado Springs, COBuilt 1978 · S/N 32R-7987089 N301CAFreiday Robert A · Kingman, AZBuilt 1967 · S/N 32-40178 N301PKHubbs Matthew · Huntersville, NCBuilt 1973 · S/N 32-7440064 N301RTSather Dean L · Amarillo, TXBuilt 1982 · S/N 32R-8229068 N301TMTlwm Private Air LLC · Tampa, FLBuilt 1991 · S/N 27-0123 N3024DBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7987057 N3024NDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1979 · S/N 32R-7987099 N30253Charter Rentals LLC · Mantua, OHS/N 32R-7887274 N3025LBeacon Aviation Flight Services LLC · Rogers, ARS/N 32R-7987092 N3025NTrue Auto Mart LLC · Belton, SCBuilt 1979 · S/N 32R-7987100 N3026CDowney Michael E · Dacono, COBuilt 1979 · S/N 32R-7987048 N3026DDirt World LLC · Boulder City, NVS/N 32R-7987058 N3028AJuliet Sierra Foxtrot LLC · Denver City, TXBuilt 1978 · S/N 32R-7987017 N3029LJenkins Jay P Jr · Amarillo, TXBuilt 1979 · S/N 32R-7987094 N302RTElston Josh Andrew · Deer Park, WABuilt 1982 · S/N 32R-8229039 N3030JJav Air LLC · Scottsdale, AZBuilt 1978 · S/N 32R-7987076 N3031APhoenix Flight LLC · Cave Creek, AZBuilt 1979 · S/N 32R-7987018 N30371Hartley Leonard T · Mineral Wells, TXBuilt 1978 · S/N 32R-7887277 N30381Harim John M · Dunbar, PAS/N 32R-7887278 N3038BJpsm Aircraft LLC · San Mateo, CABuilt 1978 · S/N 28-7911018 N303CGtair LLC · Ridgedale, MOBuilt 2005 · S/N 3257372 N30406Greenlaw Blair · Neptune Beach, FLBuilt 1978 · S/N 32R-7887279 N3041BHogue Evan M · University Place, WABuilt 1978 · S/N 32R-7985020 N3043BSimpson Jeffrey Scott · Charlotte, NCBuilt 1978 · S/N 32R-7987042 N3044KPetersen Alexander M · Laguna Beach, CABuilt 1979 · S/N 32-7940025 N3049KLodi Holdings LLC · Big Sky, MTBuilt 1978 · S/N 32R-7987090 N304LAK2 Sales LLC · Idaho Falls, IDS/N 4622033 N3050DFly 8gs LLC · Pompano Beach, FLS/N 32R-7987059 N30511N30511 LLC · Auburndale, FLBuilt 2003 · S/N 3255005 N3054HEconomy Supply Inc · Oilton, OKBuilt 1978 · S/N 32R-7987069 N3055FWilkinson Air LLC · Huntington, WVBuilt 1978 · S/N 32R-7987068 N3056DApplied Aviation LLC · Grain Valley, MOS/N 32R7987060

Back to AD 84-19-03 R1