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.

N88KGSky West Aviation Inc Trustee · Albuquerque, NMS/N 340-0510 N8907MWarden Richard L · Canby, ORBuilt 1963 · S/N TC-541 N8911UBerry John O · Dexter, NMFirst renewal noticeBuilt 1965 · S/N TC-947 N891EATvpx Ars Inc Trustee · North Salt Lake, UTS/N 335 N8924UPan American Handling LLC · Mooresville, NCBuilt 1965 · S/N TC-949 N892PMcburney: Associates LLC · Lakeway, TXBuilt 1976 · S/N TC1947 N8939MCyrier John · Lockhart, TXBuilt 1964 · S/N TC-551 N8941GHawks Eye View LLC · Roanoke, VAS/N 340A0327 N894JGMeasured Approach LLC · Wooster, OHBuilt 1972 · S/N 340-0098 N895ACTejas Cavu LLC · Wilmington, DEBuilt 1978 · S/N 340A0558 N8960MSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1963 · S/N TC-559 N8969MTriple Heaven Aircraft Leasing Inc · Anchorage, AKBuilt 1964 · S/N TC-561 N8970MAviator Air Flight School LLC · Grand Prairie, TXBuilt 1964 · S/N TC-594 N898Rare Air Aviation Services LLC · Santa Rosa, CABuilt 2005 · S/N 4019 N898LMMlm Aviation LLC · Mars Hill, NCBuilt 1977 · S/N 340A0254 N8991GAll Trimmed Out LLC · Pierre, SDBuilt 1977 · S/N 340A0329 N8991MHilgy'S Aviation LLC · Tomahawk, WIBuilt 1965 · S/N TC-937 N899ALGulfstream Givsp 1495 LLC · East Hampton, NYBuilt 2002 · S/N 1495 N899AVGilbert Charles L · Belleair, FLBuilt 1980 · S/N ME-353 N899CAAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-104 N899CZN899cz LLC · Milwaukee, WIS/N U-96 N89FDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1969 · S/N LM-124 N8BULakeair LLC · Richland, MIBuilt 1970 · S/N TC-1322 N8SSWeather Modification LLC · Fargo, NDBuilt 1973 · S/N 340-0191 N9005SKd3 LLC · Dubois, WYBuilt 1965 · S/N TC-954 N900BPColumbus State Community College · Columbus, OHBuilt 1965 · S/N LJ-61 N900MXTropical Transport Services Ltd Inc · San Juan, PRBuilt 1986 · S/N UB-55 N900TCBlanco James A · El Dorado Hills, CABuilt 1976 · S/N 340A0210 N900USSawyer Christopher William · Pensacola, FLBuilt 1979 · S/N WA-21 N900UWAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7617 N900VStratus Financial LLC · Irvine, CABuilt 1964 · S/N TC-803 N900WRReaud Wayne A · Santa Fe, NMBuilt 2000 · S/N 1416 N9011VStar Equipment Leasing LLC · Huntsville, ALBuilt 1968 · S/N TC-1157 N9017SParker Joshua T · Fort Worth, TXBuilt 1965 · S/N TC-962 N9018VTsubasa Aviation LLC · Hooper, UTBuilt 1969 · S/N TC-1296 N901AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7636 N901FXFederal Express Corp · Memphis, TNS/N 172 N9024SBorders Nowell W · Edinburg, TXBuilt 1965 · S/N TC-963 N9025QVee Tails Of Flying Cloud Inc · Excelsior, MNBuilt 1970 · S/N TC-1356 N9029VNeighbor David H · Fairway, KSBuilt 1972 · S/N TC-1485 N902AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7519 N9035SRick Aviation Inc · Newport News, VABuilt 1965 · S/N TC-956 N9038SRed Rock Flyers LLC · Flagstaff, AZBuilt 1965 · S/N TC-961 N903AAAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 7566 N903ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 33096 N903FXFederal Express Corp · Memphis, TNS/N 179 N903JBJetblue Airways Corp · Long Island City, NYBuilt 2013 · S/N 5783 N903MDMaryland Department Of Agriculture · Annapolis, MDBuilt 1968 · S/N LM-98 N904AABank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 7613 N904AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-314

Back to AD 95-26-15 R1