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.

N2VKWings & Rotors LLC · Wilmington, DES/N 61P-0328-093 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 N30176Arce George S · Roswell, GABuilt 1978 · S/N 32R-7887271 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

Back to AD 91-21-01 R1