Skip to content

Registered aircraft · 285

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-06-17') 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-06-17') 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-06-17')
    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-06-17')
  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-06-17')
  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-06-17')
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.

N101NYBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4221 N102NYBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4230 N10566Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 4267 N108EWDepartment Of The Air Force · Hanscom Afb, MABuilt 1994 · S/N 1256 N108RTMassachusetts Institute Technology · Lexington, MABuilt 1999 · S/N 1387 N10JPPvm Management LLC · Wilmington, DEBuilt 2008 · S/N 4121 N110WALacey Transport LLC · Oskaloosa, IABuilt 2009 · S/N 4179 N115LRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 4331 N11PHPegasus Wings LLC · Santa Monica, CABuilt 2005 · S/N 4030 N1221GN1221g LLC · Fort Worth, TXBuilt 2011 · S/N 4216 N127RRPhiladelphia Church Of God Inc · Edmond, OKBuilt 2006 · S/N 4063 N133RCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 4262 N141JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4115 N142HQMax Aircraft LLC · Moon Township, PABuilt 2013 · S/N 4288 N144ABFly Evolution LLC · La Puente, CABuilt 1988 · S/N 1065 N1459AG1459 Leasing LLC · Fort Lauderdale, FLBuilt 2001 · S/N 1459 N1461XBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 4041 N14717Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 4185 N151JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4134 N154FVGenav 3 LLC · Miami, FLBuilt 2014 · S/N 4318 N160LDRegistered aircraftBuilt 1989 · S/N 1115 N167ADGrok Air LLC · Miami Beach, FLBuilt 2010 · S/N 4197 N169TCFlycle LLC · Brecksville, OHBuilt 2015 · S/N 4337 N187SGSkybridge Cdl LLC · Scottsdale, AZBuilt 2011 · S/N 4242 N188SAAlliance Aviation Group LLC · Wilmington, DEBuilt 1990 · S/N 1150 N1902PTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4192 N192NCScp Aviation LLC · Boca Raton, FLBuilt 2008 · S/N 4126 N1963NWater Force One LLC · Diamond Bar, CABuilt 2012 · S/N 4268 N1979LCabana Air LLC · Frederick, MDS/N 1480 N1986RRts Administrative Service Inc · Overland Park, KSBuilt 2012 · S/N 4263 N198GSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 1098 N200CKMacs Aviation LLC · Columbus, INBuilt 2014 · S/N 4304 N203RCMingo Air LLC · Greensboro, NCBuilt 2010 · S/N 4211 N20GGoodyear Tire & Rubber Co · Akron, OHBuilt 2010 · S/N 4212 N210AMShamrock Aviation LLC · Miami, FLBuilt 2010 · S/N 4207 N21112Ihgh LLC · Salt Lake City, UTS/N 4282 N211DHHagadone Aviation LLC · Coeur D Alene, IDBuilt 2000 · S/N 1432 N212VZNapleton Aviation Group LLC · Sugar Grove, ILBuilt 2014 · S/N 4325 N213TGBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4219 N219TFMaple Holdings LLC · Kansas City, MOBuilt 2013 · S/N 4292 N221JRNorthview Aviation LLC · The Woodlands, TXBuilt 2012 · S/N 4257 N222ZZMissaglia Aviation LLC · Rochester, NYBuilt 2008 · S/N 4137 N224BHBank Of Utah Trustee · Salt Lake City, UTBuilt 2011 · S/N 4241 N227SVHeritage Double Eagle LLC · Queensbury, NYS/N 4210 N236CACypress Cove Air LLC · Phoenix, AZBuilt 1992 · S/N 1202 N236KRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4209 N236LPCrest Aviation II LLC · Newport Beach, CABuilt 2010 · S/N 4206 N237GRRed Flag Two Ltd · Miamisburg, OHBuilt 2006 · S/N 4055 N241CHTtx 2 LLC · Las Vegas, NVBuilt 2011 · S/N 4217 N2461HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4088

Back to AD 2012-06-17