Skip to content

Registered aircraft · 111

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

N101DAFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.125 N108LUMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.307 N119BJFlight Stars Az LLC · Tempe, AZBuilt 2007 · S/N 42.AC045 N127USN127us LLC · Merrimack, NHS/N 42.AC127 N132TSUtah State University · Logan, UTBuilt 2006 · S/N 42.AC018 N149WTVectors To Final LLC · Columbus, OHBuilt 2007 · S/N 42.AC046 N16ESMeow Meow LLC · Seattle, WABuilt 2007 · S/N 42.AC100 N16FAAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2007 · S/N 42.AC029 N188KUOak Street Properties LLC · Pratt, KSBuilt 2006 · S/N 42.AC020 N189YCerrit LLC · Helena, MTBuilt 2006 · S/N 42.AC033 N197TSTango Charlie Foxtrot LLC · Port Orange, FLBuilt 2006 · S/N 42.AC001 N198TSWorld Class Aviation Ltd · Bellefontaine, OHBuilt 2006 · S/N 42.AC002 N199TSWind Rising Ventures LLC · Columbus, MSBuilt 2006 · S/N 42.AC003 N205TDB&R Mcclure Limited Family Partnership · Panama City, FLBuilt 2015 · S/N 7429 N213WJDiamond N213wj Inc · Coral Gables, FLS/N 42.AC053 N215BNMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 42.AC055 N228USAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 42.347 N232DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010032 N238USMeow Meow LLC · Seattle, WABuilt 2008 · S/N 42.AC128 N242DPFlying High Again LLC · Mount Juliet, TNBuilt 2006 · S/N 42.AC032 N243TSJoerithan & Mp Aviation LLC · Whittier, CABuilt 2007 · S/N 42.AC043 N252DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010033 N253DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010034 N254DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010035 N265CCInternational Air Services Inc Trustee · Carson City, NVS/N 42.AC102 N268DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010068 N269DXPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010069 N274DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010074 N316MZBecerra George C · Northridge, CABuilt 2007 · S/N 42.AC054 N327TSTransport Services LLC · Little Rock, ARBuilt 2006 · S/N 42.AC027 N328TSMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2006 · S/N 42.AC028 N35ALTriple M Aviation Inc Trustee · Wilmington, DEBuilt 2006 · S/N 42.147 N361GSGulf States Aircraft Sales LLC · Crossville, TNBuilt 2005 · S/N 42.101 N368TSRegistered aircraftBuilt 2008 · S/N 42.AC124 N37VKHighsky Aero Inc · Arlington, TXBuilt 2005 · S/N 42.056 N384GSMabav LLC · Mooresville, NCBuilt 2006 · S/N 42.104 N415TSBeta Fleet LLC · South Burlington, VTBuilt 2006 · S/N 42.AC015 N424RPFlight Stars Az LLC · Mesa, AZBuilt 2007 · S/N 42.AC039 N42TBest Diamond 2 LLC · N Canton, OHBuilt 2007 · S/N 42.AC084 N430TSWateractive43 LLC · Auburn, CABuilt 2006 · S/N 42.AC030 N435TSMidwest Corporate Air Inc · Bellefontaine, OHS/N 42.AC035 N441AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1983 · S/N 17276091 N449TSDiamond Flight LLC · Portland, ORBuilt 2007 · S/N 42.AC049 N458TSPaine Albert J Jr · Daniels, WVBuilt 2007 · S/N 42.AC058 N459TSUtah State University · Logan, UTBuilt 2007 · S/N 42.AC059 N460LDTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2007 · S/N 42.AC066 N460TSGraham Aviation LLC · Belgrade, MTBuilt 2007 · S/N 42.AC060 N461PANichols Aviation LLC · Seattle, WABuilt 2007 · S/N 42.AC087 N465ASSequoia Insight LLC · Houston, TXBuilt 2007 · S/N 42.AC065 N469WWMx Jets Inc Trustee · Carson City, NVBuilt 2007 · S/N 42.AC074

Back to AD 2012-26-13