Skip to content

Registered aircraft · 252

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-25-07') 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-25-07') 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-25-07')
    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-25-07')
  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-25-07')
  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-25-07')
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.

N100BMBateleur Eagle Holdings II LLC · Chicago, ILBuilt 2005 · S/N 4020 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 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 N117WRWhiskey Romeo Owner LLC · Las Vegas, NVS/N 4015 N119JETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2004 · S/N 4003 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 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 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 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 N196CCPhoenix Nap Management Resources LLC · Phoenix, AZBuilt 2004 · S/N 4005 N1986RRts Administrative Service Inc · Overland Park, KSBuilt 2012 · S/N 4263 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 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 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 N247B247 Equipment LLC · Hillsboro Beach, FLBuilt 2004 · S/N 4006 N247PDDelphi Consulting LLC · Knoxville, TNBuilt 2007 · S/N 4107 N24JRWinbrook LLC · Los Angeles, CABuilt 2008 · S/N 4122 N250RJDixon John W · Aurora, ORBuilt 2014 · S/N 4308 N251HRJohnson Breeders Inc · Rose Hill, NCBuilt 2005 · S/N 4027 N25GMLap Acquisition Air LLC · Woodbury, NYBuilt 2008 · S/N 4145

Back to AD 2012-25-07