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.

N3837WWardlay Farms And Ranches Inc · Grandview, TXBuilt 1973 · S/N TH-395 N383AAAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-13 N383ASLee Holdings & Investments LLC · Marks, MSBuilt 1978 · S/N LJ-747 N383DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30346 N383JPAtlanta Air Charter Inc · Kennesaw, GABuilt 1980 · S/N BB615 N383MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 322 N383MVSouthern Cross Aircraft LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258403 N383PLambe Clarence Jr · Kernersville, NCBuilt 2001 · S/N E-3430 N383RLRescue 383 LLC · Annapolis, MDBuilt 1999 · S/N UE-383 N383TAFloatsix Leasing LLC · Lubbock, TXBuilt 2017 · S/N 208B5343 N383TKThk Holdings LLC · Cincinnati, OHBuilt 2004 · S/N 258700 N383TTWestwood Aircraft LLC · Asheville, NCBuilt 1999 · S/N E-3274 N38403United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30120 N3840USomerset Aviation LLC · Gadsden, ALBuilt 1981 · S/N E-1821 N38417United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31665 N38424United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37095 N3842UBezet Danny · Comfort, TXBuilt 1981 · S/N E-1824 N3843NShafer John P · Bridgeport, OHS/N D-1081 N38443United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31655 N38446United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31661 N3844GLandvalue Management LLC · Fresno, CABuilt 1981 · S/N E-1826 N38451United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31646 N38454United Airlines Inc · Chicago, ILBuilt 2012 · S/N 31640 N38458United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37199 N38459United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37206 N38467United Airlines Inc · Chicago, ILBuilt 2013 · S/N 33537 N38473United Airlines Inc · Chicago, ILBuilt 2013 · S/N 38702 N38479United Airlines Inc · Chicago, ILBuilt 2016 · S/N 62817 N3848NNicholson Philip G · Wichita Falls, TXBuilt 1997 · S/N E3098 N3849XBreland Quin H · Columbia, MSBuilt 1981 · S/N E-1829 N384ABArkoma Air LLC · Rockwall, TXBuilt 1997 · S/N 258339 N384DADelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30347 N384EMIsi Aviation Support Services LLC · Broken Arrow, OKBuilt 1987 · S/N 650-0144 N384GDTomahawk 360 LLC · Saint Petersburg, FLBuilt 2010 · S/N FL-706 N384TAFour Tango Alpha LLC · Anchorage, AKBuilt 2016 · S/N 208B5300 N38507Dwm Holdings Of Texas Inc · Hot Springs, ARBuilt 1981 · S/N E-1831 N3850NHayden Robert P · West Fargo, NDBuilt 1947 · S/N D-1088 N3851LFreedom Aviation Of Ne Florida LLC · Jacksonville, FLBuilt 1981 · S/N E-1832 N38537Optimumedicine LLC · Las Vegas, NVBuilt 1985 · S/N UE-158 N3853JMitchell James R · Anthem, AZBuilt 1981 · S/N E-1837 N3853LZ-Tech Research LLC · Greenville, TXBuilt 1981 · S/N E-1844 N3858NDvorak Jerry Joseph · Ravenna, OHFirst renewal noticeBuilt 1947 · S/N D-1097 N385DNDelta Air Lines Inc · Atlanta, GABuilt 1999 · S/N 30348 N385EMEmerald Aviation Inc · Manassas, VABuilt 1980 · S/N LJ923 N385HCs Aviation LLC · Lewes, DEBuilt 2008 · S/N FL610 N385RCTms Global Investments Inc · Naples, FLBuilt 1984 · S/N 117 N3864CPearce Robert W · Santa Fe, NMBuilt 1981 · S/N E-1846 N38650Sciorrotta Samuel C Jr · Gainesville, GABuilt 1981 · S/N E-1845 N3867GW & S Aviation LLC · Fountain Inn, SCBuilt 1981 · S/N TH-1251 N3868YTalewinds LLC · Litchfield Park, AZBuilt 1981 · S/N E-1852

Back to AD 2006-16-18 R1