Skip to content

AD 2006-16-18 R1

Registered aircraft · 11,798

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-16-18-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-16-18-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-16-18-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-16-18-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-16-18-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-16-18-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.

N6640XCentral Pennsylvania Aircraft Leasing LLC · Boiling Springs, PABuilt 1979 · S/N E-1532 N6641CMacdougall Jamie L · Pls Vrds Est, CABuilt 1979 · S/N E-1542 N6641MBecker Franklin B · Phillipsburg, NJBuilt 1979 · S/N E-1545 N6644JOcean Aircraft Ltd · Virginia Beach, VABuilt 1982 · S/N BB-1031 N6644KRrc Upper Freehold LLC · Farmingdale, NJS/N TH-2076 N6645BS&D Productions · Lake Havasu City, AZBuilt 1984 · S/N E-2159 N6647RBradamike LLC · Fostoria, OHBuilt 1979 · S/N E-1561 N66489Fog City Flying LLC · Dublin, OHBuilt 1983 · S/N E-2073 N6648JWindward Passage Corporation · Englewood, NJBuilt 1979 · S/N E-1514 N6649DBas Part Sales LLC · Greeley, COBuilt 1979 · S/N TH-1041 N6649LChauza Edward J · Mesa, AZBuilt 1979 · S/N E-1516 N664CEPride Aviation Support LLC · Exeter, PABuilt 2004 · S/N 560-0664 N664FEFederal Express Corp · Memphis, TNBuilt 1995 · S/N 768 N664MMAquarius Aircraft Leasing LLC · Nashville, TNBuilt 1984 · S/N 650-0037 N664SKenney Michael D · Lucas, TXBuilt 1978 · S/N 421C0467 N664SCAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1985 · S/N 258032 N66514Vintage Aviation Medical Associates LLC · Wilmington, DEBuilt 1979 · S/N E-1522 N66518Daly Stephen M · Oakland, FLBuilt 1979 · S/N TH-1044 N66519George Jon L · Gulf Shores, ALBuilt 1982 · S/N E-2054 N6652RDrummond Williams D · Bloomington, INBuilt 1979 · S/N E-1524 N6652YSeiger Thomas W · Medford, ORS/N E-1525 N6654YLewis Garry L · Livingston, LABuilt 1979 · S/N TH-1061 N6655GRight Wing Left Wing Flyers LLC · Cleveland, GABuilt 1968 · S/N E-89 N6655QDurham Aviation LLC · Henrietta, TXS/N E-1740 N6655YBretts Spray Service Inc · Onida, SDBuilt 1979 · S/N E-1559 N6656WBonanza Partners Of Kc LLC · Shawnee, KSBuilt 1983 · S/N E-2075 N6658SKgb58 Aviation LLC · Gibsonia, PAS/N TH-681 N665FEFederal Express Corp · Memphis, TNBuilt 1996 · S/N 769 N665JKSprinklermatic Florida LLC · Davie, FLBuilt 1975 · S/N LJ665 N665RCDouble Aught Dairy LLC · Dexter, NMBuilt 2025 · S/N 525-1192 N66619West Bend Air Inc · West Bend, WIBuilt 1979 · S/N TH-1070 N6661YSchlosser David · Scottsdale, AZBuilt 1979 · S/N TH-1068 N6662NRegistration Pending · Uvalde, TXRegistration pendingS/N TH-1073 N6666XBlack Sheep Aviation LLC · Palm City, FLBuilt 1979 · S/N TH-1093 N6668QRegistered aircraftBuilt 1983 · S/N E-2077 N666BZCorrao Ludwig Jerome Trustee · Reno, NVBuilt 2019 · S/N 20800652 N666CNHamon John · Paso Robles, CABuilt 1979 · S/N E-1470 N666DSDaviator LLC · Homer, AKBuilt 1985 · S/N S550-0056 N666KLWj Of Delaware Inc · Fort Lauderdale, FLS/N 040 N666WLM Holdings Aero LLC · Wilmington, DES/N E-2216 N6670ZMortan Robert F · Mckinney, TXBuilt 1979 · S/N E-1585 N66719Dusch William C · Concord, NCBuilt 1983 · S/N E-2078 N6671DGruber Mark W · Edmond, OKBuilt 1979 · S/N E-1613 N6671LArias Aviation Inc · Wilmington, DEBuilt 1983 · S/N E-2079 N6671XDairy Air LLC · Mount Crawford, VABuilt 1979 · S/N TH-1077 N66722Lumpkin Ed · Rosie, ARS/N E-2081 N6672BYour World Inc · Draper, UTBuilt 1979 · S/N E-1584 N6672KMaremy LLC · Ramona, CABuilt 1979 · S/N E-1564 N6677YBrown Hunter L · Sulphur Rock, ARBuilt 1979 · S/N E-1594 N6679APegasus Specialty Leasing Inc · Paris, TXBuilt 1983 · S/N E-2082

Back to AD 2006-16-18 R1