OpenAirDocs.org
AD 2006-19-11

Registered aircraft · 33

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
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-19-11')
    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-19-11')
  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.

N13AVGrant Aviation Inc · Anchorage, AKBuilt 2003 · S/N GA8-03-028N152VPConservation Aviation LLC · Washington, DCBuilt 2011 · S/N GA8-11-160N215AVNational Test Pilot School · Mojave, CABuilt 2002 · S/N GA8-02-015N234EAApache Airvan LLC · Greenville, DES/N GA8-02-021N26NANatron Air Inc · Soldotna, AKBuilt 2002 · S/N GA8-02-018N291BWWings Over Kauai LLC · Kalaheo, HIBuilt 2017 · S/N GA8-17-240N470CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-068N471CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-070N472CPInternational Air Services Inc Trustee · Carson City, NVS/N GA8-05-072N474CPCamber Aviation LLC · Mesa, AZS/N GA8-05-077N525AVGlobal Air Concepts LLC · Anchorage, AKBuilt 2016 · S/N GA8-16-227N578GVGrant Aviation Inc · Anchorage, AKBuilt 2004 · S/N GA8-04-066N588AVAir Ventures Hawaii LLC · Lihue, HIBuilt 2005 · S/N GA8-05-076N601BZN501bz LLC · Boca Raton, FLS/N GA-8-04-064N605CPInternational Air Services Inc Trustee · Carson City, NVS/N GA8-03-030N606CPGrant Aviation Inc · Anchorage, AKBuilt 2003 · S/N GA8-03-036N607CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-049N608CPWings Over Kauai LLC · Kalaheo, HIS/N GA8-04-052N609CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-054N610CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-056N611CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-058N612CPCivil Air Patrol · Maxwell Afb, ALS/N GA8-04-060N613CPGrant Aviation Inc · Anchorage, AKS/N GA8-04-062N616AVSouthern Aviation Ga LLC · Anchorage, AKBuilt 2016 · S/N GA8-16-228N617AVSouthern Aviation Ga LLC · Anchorage, AKBuilt 2016 · S/N GA8-16-230N699AVAir Ventures Hawaii LLC · Lihue, HIBuilt 2006 · S/N GA8-06-106N7050FCity Of Houston · Houston, TXBuilt 2020 · S/N GA8-20-262N721AVAir Ventures Hawaii LLC · Lihue, HIBuilt 2007 · S/N GA8-07-121N7508MWings Over Kauai LLC · Kalaheo, HIS/N GA8-05-094N753SEInternational Air Services Inc Trustee · Carson City, NVBuilt 2014 · S/N GA8-15-209N822AVAir Ventures Hawaii LLC · Lihue, HIS/N GA8-05-082N841MBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N GA8-04-047N916RKGrant Aviation Inc · Anchorage, AKBuilt 2012 · S/N GA8-12-176
Back to AD 2006-19-11