Skip to content

AD 2006-04-13 R1

Registered aircraft · 672

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:2006-04-13-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:2006-04-13-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:2006-04-13-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:2006-04-13-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:2006-04-13-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:2006-04-13-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.

N242GMTrans-Exec Air Service Inc · Van Nuys, CABuilt 2007 · S/N 5123 N245BDBs Farms Aviation LLC · Menlo Park, CABuilt 2007 · S/N 5165 N245TTWotan America Inc · Fort Lauderdale, FLBuilt 2003 · S/N 5003 N2461HTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4088 N247B247 Equipment LLC · Hillsboro Beach, FLBuilt 2004 · S/N 4006 N247EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 5265 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 N252DVG550 Aviation LLC · Grand Rapids, MIBuilt 2014 · S/N 5463 N257ATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 5571 N25GMLap Acquisition Air LLC · Woodbury, NYBuilt 2008 · S/N 4145 N25HLWilmington Trust Company Trustee · Wilmington, DEBuilt 2005 · S/N 5066 N25UTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5359 N261PWPerryair LLC · New York, NYBuilt 2010 · S/N 5268 N265SHSea Hunt Boat Mfg Co Inc · Sumter, SCBuilt 2013 · S/N 4290 N269WRWestgate Aviation Giv LLC · Orlando, FLBuilt 2007 · S/N 5153 N26RXRxjet Transportation Services Corp · Oxford, CTBuilt 2013 · S/N 5425 N272BGFalcon Landing LLC · Hawthorne, CABuilt 2007 · S/N 5164 N273ATisma Holdings Inc · Fairfax, VABuilt 2010 · S/N 5273 N275MSkyknight LLC · Greeneville, TNBuilt 2006 · S/N 4048 N279SHMeneses Enterprises LLC · Houston, TXBuilt 2019 · S/N 5605 N279WRTelemachus LLC · New York, NYBuilt 2014 · S/N 5497 N27LXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 5511 N283PHGlobal Services Detroit LLC · Detroit, MIBuilt 2015 · S/N 5505 N284PHGlobal Services Detroit LLC · Detroit, MIBuilt 2014 · S/N 5480 N285PHGlobal Services Detroit LLC · Detroit, MIBuilt 2015 · S/N 5522 N28ADBlue Collar Inc · New York, NYBuilt 2013 · S/N 4284 N294DLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2008 · S/N 4138 N2DFSuburban Properties 3 LLC · Birmingham, MIS/N 4096 N302SBSchell Brothers II LLC · Rehoboth Beach, DEBuilt 2003 · S/N 5026 N303BDFjb 16720 LLC · The Woodlands, TXBuilt 2004 · S/N 5058 N305AHNf Air Ventures II LLC · Troy, MIBuilt 2009 · S/N 5264 N305GPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4106 N306BDDp Holdings LLC · Davenport, IABuilt 2011 · S/N 5354 N308KGRegistered aircraftBuilt 2006 · S/N 5111 N30LSTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 5228 N30SNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 5380 N310TZFl Jet LLC · Fort Myers, FLBuilt 2003 · S/N 5028 N3131A313 Aviation Holdings LLC · Miami Beach, FLBuilt 2003 · S/N 5021 N314TPTutor Perini Corporation · Sylmar, CABuilt 2006 · S/N 5104 N316GNGeneral Industries LLC · Camden, NJBuilt 2012 · S/N 5389 N316VAAvation LLC · Grand Rapids, MIBuilt 2015 · S/N 5530 N318DCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 4229 N319CRKangaruby LLC · Wilmington, DEBuilt 2009 · S/N 5260 N319FSBanc Of California · Chicago, ILBuilt 2020 · S/N 5621 N319STTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 5114 N31BGGsbg Asset Holdings LLC · Atlanta, GABuilt 2011 · S/N 4243 N320JMBlaise Carolina LLC · Wilmington, DEBuilt 2005 · S/N 4035

Back to AD 2006-04-13 R1