Skip to content

Registered aircraft · 5,440

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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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:95-26-15-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.

N421BJRegistered aircraftBuilt 1968 · S/N TC-1057 N4222ATenax Air LLC · Ridgeland, MSBuilt 2001 · S/N UE-422 N422AXAlpine Aviation Inc · Provo, UTBuilt 1989 · S/N UC-95 N422BNAntares Aviation LLC · Boca Raton, FLBuilt 1973 · S/N 20735 N423AXOmni Planes LLC · Tulsa, OKBuilt 1996 · S/N 27569 N423RBAdams Aviation Services Inc Owner Trustee · Wilmington, DEBuilt 1981 · S/N 340A1270 N424JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 1444 N424MEKfl LLC · Canyon Country, CABuilt 1976 · S/N 340A0051 N424PCMontana Livestock Ag Credit Inc · Helena, MTS/N 340A1266 N425JMccracken Lester G · Edinboro, PABuilt 1958 · S/N TD-57 N425RGUpstate Aircraft LLC · Old Forge, NYS/N 340A0976 N4264CMmc Properties LLC · Cottonwood, AZBuilt 1978 · S/N 340A0516 N4267SJjk Aviation LLC · Wilmington, DEBuilt 1977 · S/N TC-2037 N426AVAircol 10 · Wilmington, DEBuilt 2009 · S/N 4026 N426UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 510 N427KMAviation Advantage LLC · Phoenix, AZBuilt 1974 · S/N TC-1818 N427UAUnited Airlines Inc · Chicago, ILFirst renewal noticeBuilt 1995 · S/N 512 N4287AWilliam Dolson And Associates LLC · Santa Fe, NMBuilt 1980 · S/N 340A1010 N4287SLemanski Joseph S · Fiskdale, MABuilt 1977 · S/N TC-2112 N428KSSn 1360 LLC · Wilmington, DEBuilt 1999 · S/N 1360 N428UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 523 N429CGRica Air LLC · Castaic, CABuilt 2002 · S/N 1499 N429DDAircraft Trust & Financing Corp Trustee · Wilmington, DEBuilt 1996 · S/N 1293 N429GLHamilton Verlon D · Roanoke, TXBuilt 1965 · S/N TC-868 N429MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24833 N429UAUnited Airlines Inc · Chicago, ILBuilt 1995 · S/N 539 N42HFKlochko Oleg Alexander · Furlong, PABuilt 1974 · S/N TC-1730 N42JWBusiness Aircraft Leasing Inc · Petersburg, ILBuilt 1965 · S/N TC-884 N42RRWalla Walla University · College Place, WAS/N ME-84 N4304Bank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 4304 N4304CN4304c LLC · Pawhuskah, OKBuilt 1980 · S/N 340A1011 N430FEFederal Express Corp · Memphis, TNBuilt 1985 · S/N 394 N430UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 568 N4310WSt Clair Joseph M · Wills Point, TXBuilt 1974 · S/N TC-1651 N4315COld Salt Aviation LLC · Virginia Beach, VABuilt 1978 · S/N 340A0532 N4319SMac Air Inc · Farmington, MOBuilt 1975 · S/N TC-1869 N431AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24632 N431BCJahn431bc LLC · Miami, FLBuilt 1991 · S/N 340B-260 N431FEFederal Express Corp · Memphis, TNBuilt 1984 · S/N 316 N431UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 571 N432Lazy J Aeroplanes LLC · Beverly, WVBuilt 1974 · S/N TC-1649 N4326CSeven Echo Whiskey Corp · Wilmington, DEBuilt 1976 · S/N 340A0075 N432AXCargo Aircraft Management Inc · Wilmington, OHBuilt 1995 · S/N 27449 N432CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-432 N432HCFast Bird LLC · Wilmington, DEBuilt 1995 · S/N 1262 N432RADirect Entry Holdings LLC · Port Richey, FLBuilt 1979 · S/N 340A0925 N432UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 587 N4337WPeterson Arnold L · Gardnerville, NVBuilt 1974 · S/N TC-1665 N433AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1989 · S/N 24400 N433UAUnited Airlines Inc · Chicago, ILBuilt 1996 · S/N 589

Back to AD 95-26-15 R1