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.

N3802JDental Surgical Center Of Medina Inc · Medina, OHS/N E-1781 N3802PCassill Aircraft Leasing Inc · Cedar Rapids, IABuilt 1980 · S/N E-1782 N3804ABig Love LLC · Tifton, GABuilt 1983 · S/N TH-1381 N3805EHollow Creek Investments LLC · Germantown, TNBuilt 1981 · S/N LJ-943 N3806LPeterson Ross D · Hutchinson, MNBuilt 1980 · S/N E-1793 N3806XTessec LLC · Cincinnati, OHBuilt 1980 · S/N TH-1215 N3807EDonaghe Larry Chance · Rockwall, TXBuilt 1981 · S/N E-1809 N3807NTanner Byron D · Saint Amant, LABuilt 1947 · S/N D-1035 N38081Heitmeier Cody F · New Orleans, LAS/N E-1798 N38089Dabbs Randal L · Lenoir City, TNBuilt 1980 · S/N TH-1218 N3809CRepublic Refrigeration Inc · Monroe, NCBuilt 1981 · S/N LA-112 N3809KGeneral Aviation Services LLC · Franklin, TNBuilt 1981 · S/N TH-1219 N380CFBarkley Air LLC · Scottsboro, ALBuilt 1996 · S/N 560-0380 N380DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30266 N380JPPaalmc Llv · Shreveport, LAS/N BB-1889 N380KMTfg Holdings LLC · Greenville, SCBuilt 2001 · S/N FL321 N380PCRhomberg Bernard B · Elm Grove, WIBuilt 1978 · S/N E-1384 N3810ZFalcon Ridge Industries Inc · Milleville, NJBuilt 1980 · S/N E-1802 N3814NChapman Stuart M · Vernon, COBuilt 1947 · S/N D-1043 N3815NEllett Tommy A · Ferriday, LABuilt 1947 · S/N D-1044 N3815PNorth Louisiana Aviation LLC · Mer Rouge, LABuilt 1981 · S/N E-1850 N38168Jjj&S Aviation Corp · Brooklyn, NYBuilt 1981 · S/N E-1808 N3816SKey Field Flyers LLC · Toomsuba, MSBuilt 1981 · S/N E-1806 N3818C18 Charlie LLC · Southern Pines, NCBuilt 1976 · S/N LW-196 N3818NFlorida State College At Jacksonville · Jacksonville, FLBuilt 1947 · S/N D-1047 N381BJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N 501-0286 N381CRSiemsen Randall R · Clovis, CABuilt 1976 · S/N E-875 N381CWN650rj LLC · Marshall, MNBuilt 1986 · S/N 650-0111 N381DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30350 N381HCIntermountain Medical Transport LLC · Salt Lake City, UTS/N BB-1952 N381RUc Aviation Holdings LLC · Union City, TNBuilt 1978 · S/N BB-385 N381SUTextron Aviation Inc · Wichita, KSS/N FL-1380 N381TAHigher4hire LLC · Miami Beach, FLBuilt 2018 · S/N 208B5434 N3822NLohmann Heinrich F · Saint Louis, MOBuilt 1947 · S/N D-1054 N38257United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30612 N3825MMckendry Scott P · Sanford, NCBuilt 1981 · S/N E-1813 N3825NMorrison Benjamin F · Godley, TXBuilt 1947 · S/N D-1062 N3825XBliss Aviation LLC · Somerville, TNBuilt 1981 · S/N TH-1230 N38268United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31587 N3826NWahl Christopher S · Jerseyville, ILS/N D-1063 N38280Aerotrust Services Corp Trustee · Wilmington, DES/N LJ-953 N38282Zemetis Terence A · Meriden, CTBuilt 1981 · S/N E-1819 N3828NSallustio Eric · Lake Butler, FLBuilt 1981 · S/N E-1818 N3829NCostello John J Jr · Carlsbad, CABuilt 1947 · S/N D-1066 N382BWWd Aviation Group Inc · Atlanta, GAS/N 421C0711 N382DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30345 N382TASeaplane LLC · Fort Lauderdale, FLBuilt 2018 · S/N 208B5430 N382TCSkylink Jets Inc · Fort Lauderdale, FLS/N 039 N3831NTilghman Charles R Jr · Van Alstyne, TXBuilt 1947 · S/N D-1068 N3835NHaraway David D · Tulsa, OKBuilt 1947 · S/N D-1072

Back to AD 2006-16-18 R1