Skip to content

AD 2011-06-06 R1

Registered aircraft · 250

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:2011-06-06-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:2011-06-06-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:2011-06-06-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:2011-06-06-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:2011-06-06-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:2011-06-06-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.

N417CGSpeed Holdings LLC · Deland, FLS/N 000094 N426CBEcho Alpha Inc · Wayne, NJBuilt 2017 · S/N 550-1013 N427XJennairic LLC · Wilmington, DEBuilt 2008 · S/N 000253 N429CCPei Holdings LLC · Boise, IDBuilt 2007 · S/N 000060 N434MTLwmfs LLC · Plantation, FLBuilt 2007 · S/N 000061 N435NFPapa Charlie LLC · Fort Myers, FLBuilt 2008 · S/N 000189 N444RLA-Ron Resources LLC · Santa Monica, CABuilt 2007 · S/N 000040 N448HCFagawee International Inc · Palm Beach Gardens, FLBuilt 2008 · S/N 000161 N450NEGraybeal Solutions LLC · Pendleton, ORS/N 550-0280 N450RBC & H Aviation LLC · Cincinnati, OHBuilt 2008 · S/N 000165 N456MFFive Ducks LLC · Boston, MABuilt 2007 · S/N 000050 N457TBLennox Aviation LLC · Boston, MABuilt 2007 · S/N 000088 N461NSummiting LLC · Fountain Hills, AZBuilt 2008 · S/N 000234 N464PGNeelu Aviation LLC · Columbus, OHS/N 000096 N465DGKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2008 · S/N 000250 N478FUniversity Transplant Associates Pc · Portland, ORBuilt 2008 · S/N 000228 N48KYN48ky LLC · Medina, OHBuilt 2008 · S/N 000178 N49PLHayes Jeffrey · Miami, FLBuilt 2008 · S/N 000255 N500CDColumbus Citywide Heating & Cooling Inc DBA · Boerne, TXBuilt 2007 · S/N 000045 N500CEConstellation Productions Inc · Irvine, CABuilt 2008 · S/N 000157 N500DGBlue Grass Capital Holdings LLC · Naples, FLBuilt 2008 · S/N 000129 N500EARe Capital Holdings LLC · Sarasota, FLBuilt 2007 · S/N 000095 N500EMEclipse Jet Partners LLC · Charlotte, NCBuilt 2007 · S/N 000026 N500FBHatch Investments LLC · Grand Junction, COBuilt 2008 · S/N 000185 N500MMTak Aviation LLC · Wilmington, DEBuilt 2008 · S/N 000139 N500UHModualr Aviation LLC · Saratoga Springs, UTBuilt 2008 · S/N 000188 N500VHAdams Air LLC · Newark, DEBuilt 2008 · S/N 000211 N500ZHOsprey Aircraft Holdings LLC · Hilton Head Island, SCBuilt 2008 · S/N 000158 N501DXAb Monterrey Aircraft LLC · San Antonio, TXBuilt 2008 · S/N 000110 N502ETValiair Lc Trustee · Casper, WYBuilt 2007 · S/N 000052 N504MPVelocity Aviation LLC · Kalispell, MTBuilt 2008 · S/N 000144 N504TCQuantum Aviation LLC · Fort Worth, TXBuilt 2008 · S/N 000141 N508CPEclipse Aviation LLC · Salt Lake City, UTBuilt 2008 · S/N 000196 N508JACalvin Stoltzfus · Great Falls, MTBuilt 2006 · S/N 000001 N508JPEclipse Jet 71 LLC · Thomasville, GABuilt 2007 · S/N 000071 N509JAJet-Alliance # 84 LLC · Moorpark, CABuilt 2007 · S/N 000084 N50EJ83gt LLC · Alpharetta, GABuilt 2007 · S/N 000087 N512MBReed Bart Taylor Trustee · Norman, OKS/N 000175 N514EAGore Air LLC · San Juan, TXS/N 000053 N516EASaw Whet LLC · Denver, COBuilt 2008 · S/N 000106 N518WDAtlas Aviation LLC · Texarkana, ARBuilt 2008 · S/N 000209 N519EJBroskair LLC · Francesville, INBuilt 2007 · S/N 000019 N522DKBonanza Five Five Victor LLC · Pompano Beach, FLBuilt 2007 · S/N 000105 N527MAValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 000007 N528EAMhi Aviation LLC · Saint Rose, LABuilt 2008 · S/N 000128 N52ELAngelic Air III LLC · Fredericksburg, TXBuilt 2008 · S/N 000156 N539RMGulf Atlantic Airways Inc · Gainesville, FLS/N 000101 N53WATak Aviation LLC · Wilmington, DEBuilt 2007 · S/N 000044 N541LBSiktberg Timothy J · Nashville, TNBuilt 2007 · S/N 000041 N546BWEnmon Enterprises LLC · Harahn, LABuilt 2007 · S/N 000025

Back to AD 2011-06-06 R1