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.

N3767Delta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30821 N3768Delta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29630 N3769LDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 30822 N376DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29624 N376JXAircraft Structures International Corp · Enid, OKFirst renewal noticeS/N 208B0748 N37700Delta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29631 N3771KDelta Air Lines Inc · Atlanta, GABuilt 2002 · S/N 29632 N3772HDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30823 N3773DDelta Air Lines Inc · Atlanta, GABuilt 2010 · S/N 30825 N3777NBonanza Parts Inc · Davis, CABuilt 1947 · S/N D-999 N3777SStuart Guy · Owosso, MIBuilt 2000 · S/N E-3351 N3778NOliphant Jack · Fort Collins, COBuilt 1947 · S/N D-1000 N377AMJohnstone Inc · Wilsonville, ORS/N E-63 N377DShawn Wyatt Enterprises Inc · Huntsville, TXBuilt 1983 · S/N E-2087 N377DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 29625 N377JEAcr Advertising LLC · Jasper, INS/N BB-1843 N377JMSanchez Joshua A · Bosque, NMBuilt 1976 · S/N 421C0221 N377KCEagle Flying Club LLC · Enid, OKBuilt 1977 · S/N E-1032 N377PUig Transport LLC · Raleigh, NCBuilt 1984 · S/N LJ-1087 N377PGJackalope Air LLC · Afton, WYBuilt 2022 · S/N 525-1133 N377SUTextron Aviation Inc · Wichita, KSS/N FL-1377 N377TMuffler Ronald J Trustee · Salt Lake City, UTS/N E3416 N377TASeven Tango Alpha LLC · Ft Lauderdale, FLS/N 208B5123 N3781NOkeefe John Thomas · Winthrop, WABuilt 1947 · S/N D-1003 N3787NAircraft Partner Holdings Inc Trustee · BerlinBuilt 1947 · S/N D-1010 N378AWSkyline Aviation Services LLC · Miramar, FLS/N UE-378 N378BGDiscovery One LLC · Windsor, COS/N FL-453 N378DNational Test Pilot School · Mojave, CABuilt 1975 · S/N 306-101 N378DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30265 N378KAga Aviation LLC · Lewes, DES/N 421C0499 N378SFTrigg David D · Houston, TXBuilt 1978 · S/N BB-378 N3791NLabs Kevin A · Citrus Heights, CABuilt 1947 · S/N D-1014 N3798NAviation Business Corp · Saint Louis, MOBuilt 1947 · S/N D-1160 N3799MWaldron Ronald · Strongsville, OHBuilt 1980 · S/N E-1774 N379BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 20800414 N379DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30349 N379DWAircraft Structures International Corp · Enid, OKFirst renewal noticeS/N 208B-0699 N379ECRebus II LLC · Owasso, OKBuilt 2003 · S/N 560-0642 N379EKAvtrust LLC Trustee · Wilmington, DEBuilt 2001 · S/N BB-1769 N379VMShores Kenneth E · Robstown, TXBuilt 1972 · S/N LW-27 N37BRC&D Pharmaceuticals Berry Inc · Berry, ALBuilt 1981 · S/N E-1860 N37BSMatthew Davis · Asheville, NCBuilt 1974 · S/N E-548 N37CHDehaan Aviation LLC · Bethel, AKBuilt 1979 · S/N E-1460 N37JWNetwork Sales & Leasing Inc · Newtown, PABuilt 2012 · S/N 208B5001 N37RAGustafson John A Trustee · Boulder City, NVBuilt 2001 · S/N E-3422 N37RCCorrao Robert F Jr · Scottsdale, AZBuilt 1995 · S/N E-2986 N37RZOwens Martin · Telluride, COBuilt 1979 · S/N 421C0823 N37TDTwin Disc Inc · Racine, WIBuilt 1990 · S/N FL-25 N37WXCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 309 N38020Pardue Hines Aviation LLC · Lincolnton, NCBuilt 1980 · S/N TH-1208

Back to AD 2006-16-18 R1