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.

N549AFTak Aviation LLC · Wilmington, DEBuilt 2007 · S/N 000049 N54KJSwu LLC · Boston, GABuilt 2007 · S/N 000091 N54TE911 Fleet Aviation LLC · Mount Pleasant, SCBuilt 2007 · S/N 000054 N550DMDirect Jet LLC · Redwood Shores, CABuilt 2016 · S/N 550-1009 N550FValiair Limited Company Trustee · Casper, WYBuilt 2015 · S/N 550-1001 N550NJWolverine Property Management LLC · Fenton, MIBuilt 2016 · S/N 550-1008 N550SEKd Air LLC · San Diego, CABuilt 2016 · S/N 550-1007 N550UZ722 Holdings Inc · Miami, FLBuilt 2016 · S/N 550-1006 N555EJRegistered aircraftBuilt 2008 · S/N 000183 N55BXPegasus Royalty Group LLC · Bozeman, MTBuilt 2007 · S/N 000029 N55TJCollier Companies Aviation LLC · Gainesville, FLBuilt 2008 · S/N 000208 N561MJAngel Flight Celebration Inc · Celebration, FLBuilt 2008 · S/N 000140 N563MJRegistered aircraftBuilt 2007 · S/N 000027 N568PBTac Air LLC · Peachtree City, GABuilt 2007 · S/N 000067 N570EAAmicus Curiae LLC · Chicago, ILBuilt 2007 · S/N 000070 N575CCCrank Kim · Little Rock, ARBuilt 2007 · S/N 000075 N575EJEclipse Aerospace Inc · Albuquerque, NMBuilt 2024 · S/N 550-1016 N576EAJgdg Holdings LLC · Lake Charles, LABuilt 2007 · S/N 000076 N580WCOller Dean H · Indianapolis, INBuilt 2007 · S/N 000080 N58EHAircraft Partner Holdings Inc Trustee · BerlinBuilt 2008 · S/N 000171 N58KYRmi Air LLC · Ocilla, GABuilt 2007 · S/N 000016 N58VLForest Air LLC · Sands Point, NYBuilt 2008 · S/N 000130 N607LMKnight Eagle Investments LLC · Brentwood, TNBuilt 2008 · S/N 000204 N6100Contrails LLC · Dover, DEBuilt 2007 · S/N 000046 N610PWGimp LLC · Ponca City, OKBuilt 2017 · S/N 550-1011 N615RHHeidrich Aviation LLC · White Lake, MIBuilt 2007 · S/N 000068 N619RJEclipse 231 LLC · El Cajon, CABuilt 2008 · S/N 000231 N61DTEast Tennessee Aircraft LLC · Johnson City, TNBuilt 2008 · S/N 000192 N61HFSmal LLC · Atlanta, GABuilt 2007 · S/N 000012 N62RCEclipse Jet LLC · Forest, VABuilt 2007 · S/N 000043 N62TE62 Group LLC · Bountiful, UTBuilt 2007 · S/N 000062 N63ADDg Aircraft Holdings LLC · Eagle Point, ORBuilt 2008 · S/N 000163 N6462MTak Aviation LLC · Wilmington, DEBuilt 2008 · S/N 000200 N646WTD And K Aviation LLC · Greenwood, INBuilt 2008 · S/N 000225 N656FPCatmark Enterprises LLC · Richmond, VTBuilt 2013 · S/N 550-0265 N66BXTak Aviation LLC · Wilmington, DEBuilt 2008 · S/N 000154 N66WTWhiskey Tango Foxtrot Motorsports LLC · Scottsdale, AZBuilt 2007 · S/N 000100 N675KMFlyguys LLC · Rensselaer, INBuilt 2006 · S/N 000002 N678PSEuroaviation Inc Trustee · KematenBuilt 2008 · S/N 000191 N67LPJolly Air LLC · Collierville, TNBuilt 2008 · S/N 000236 N6CCFlight Club Aviation LLC · Auburn, ALBuilt 2007 · S/N 000078 N703BRSchick Robert O · Pensacola Beach, FLBuilt 2007 · S/N 000064 N705PTCason Aviation LLC · Spring, TXS/N 000014 N707ESRegistration Pending · Brookhaven, MSRegistration pendingBuilt 2008 · S/N 000232 N70EJLg Jet Investments LLC · Scottsdale, AZBuilt 2008 · S/N 000194 N712WGKbork Management LLC · Wichita Falls, TXBuilt 2008 · S/N 000180 N717HDGray & Co Inc · Metairie, LABuilt 2007 · S/N 000113 N718RBFeb14 Aviation LLC · Carmel, INBuilt 2008 · S/N 000218 N71FEInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 000023 N722TDDe Koning Inc · Glen Allen, VABuilt 2008 · S/N 000224

Back to AD 2011-06-06 R1