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.

N411LLGlen Hill Sky LLC · Oakbrook Terrace, ILBuilt 2015 · S/N 4329 N412TJ400tj Inc · Newport Beach, CABuilt 2013 · S/N 4278 N415BTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2011 · S/N 5312 N415DSNexa Aviation LLC · Burlingame, CAS/N 5090 N415QSRegistered aircraftBuilt 2005 · S/N 4014 N41PMSouthland Holding Group LLC · Beverly Hills, CABuilt 2007 · S/N 5177 N421QSRegistered aircraftBuilt 2008 · S/N 4114 N4249Tvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 4249 N424EATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 5234 N424PXNf Air Ventures LLC · Southfield, MIBuilt 2007 · S/N 4101 N425TMIntellectual Air LLC · Atlanta, GABuilt 2008 · S/N 5191 N42JHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2003 · S/N 5024 N435QSDodson International Parts Inc · Rantoul, KSBuilt 2006 · S/N 4068 N43ADAngstrom Aviation LLC · Southfield, MIS/N 4202 N43XTAero Leasing II LLC · Apex, NCBuilt 2004 · S/N 4009 N441GCBryancore Aviation LLC · Key Biscayne, FLBuilt 2013 · S/N 5441 N444DHHatley Aviation LLC · Johnson City, TNBuilt 2005 · S/N 5084 N445HCastor-G550 LLC · North Miami Beach, FLBuilt 2007 · S/N 5163 N445QSDodson International Parts Inc · Rantoul, KSBuilt 2006 · S/N 4037 N447JFN447jf LLC · New Hudson, MIBuilt 2010 · S/N 4187 N448QSNji Sales Inc · Oklahoma City, OKBuilt 2007 · S/N 4100 N450ABBlue Vista LLC · Newport Beach, CABuilt 2006 · S/N 4043 N450ARN450ar LLC · Henderson, NVBuilt 2005 · S/N 4032 N450BGT Champsions Houston LLC · Dallas, TXBuilt 2007 · S/N 4081 N450BTTw Aviation LLC · Jupiter, FLBuilt 2006 · S/N 4065 N450BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 4357 N450CEBlue Flag Two Ltd · Miamisburg, OHBuilt 2012 · S/N 4250 N450DTAll Island Charter LLC · Woodbury, NYBuilt 2003 · S/N 4004 N450FKAircraft T&F LLC Trustee · Wilmington, DEBuilt 2005 · S/N 4031 N450FXService Electric Co · Cleveland, OHBuilt 2015 · S/N 4330 N450GAGulfstream Leasing LLC · Savannah, GABuilt 2007 · S/N 4098 N450GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 4082 N450JCSunshine State Capital Management LLC · Naples, FLBuilt 2012 · S/N 4255 N450JSDjb Aviation LLC · Hackensack, NJBuilt 2015 · S/N 4344 N450LMillard Management Company LLC · Omaha, NEBuilt 2010 · S/N 4213 N450LVKendall Road Pegasus LLC · Chicago, ILBuilt 2006 · S/N 4061 N450MEPopping Up Everywhere LLC · Las Vegas, NVBuilt 2017 · S/N 4361 N450MHRegistered aircraftBuilt 2011 · S/N 4232 N450PDKag Services LLC · Meridian, IDBuilt 2014 · S/N 4312 N450PUAstra Holdings Inc · Wilmington, DEBuilt 2007 · S/N 4095 N450QSNji Sales Inc · Oklahoma City, OKBuilt 2006 · S/N 4046 N450SMJohn R Miller Enterprises V LLC · Salt Lake City, UTBuilt 2008 · S/N 4112 N450VAJe Air LLC · Corona Del Mar, CABuilt 2008 · S/N 4131 N450VMTtx 2 LLC · Las Vegas, NVBuilt 2015 · S/N 4342 N450WBBindley Aviation LLC · Indianapolis, INBuilt 2008 · S/N 4110 N450WCPark Landing Aviation LLC · Madison, NJBuilt 2006 · S/N 4042 N450XXJmjmac Holdings LLC · Miramar, FLBuilt 2006 · S/N 4062 N450ZG650 LLC · Bloomfield Hills, MIBuilt 2005 · S/N 4012 N451BHHerd Michael A · Tyler, TXBuilt 2009 · S/N 4157 N451FXLmt Illumination LLC · Cleveland, OHBuilt 2015 · S/N 4332

Back to AD 2006-04-13 R1