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.

N60041Chino Farms Aviation LLC · Valley Center, CABuilt 2026 · S/N 20800726 N6005MTextron Aviation Inc · Wichita, KSS/N 208B5977 N6005WTextron Aviation Inc · Wichita, KSS/N 208B5990 N6006ATextron Aviation Inc · Wichita, KSS/N 208B5986 N6006PTextron Aviation Inc · Wichita, KSS/N 208B5989 N6009JBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N FL-709 N600ACLowcountry Aviation Co Brokerage LLC · Walterboro, SCBuilt 1976 · S/N LW-185 N600AFClark Development LLC · Dekalb, ILBuilt 1980 · S/N E-1803 N600ALSale Reported · Trumann, ARSale reportedBuilt 2000 · S/N 525-0383 N600BBGat Air & Ground LLC · Norwich, NYFirst renewal noticeBuilt 1981 · S/N TH-1236 N600BWLambert Mcguire Management LLC · Austin, TXBuilt 2004 · S/N 560-0671 N600CAWilmington Trust Co Trustee · Wilmington, DEBuilt 2002 · S/N FL-339 N600CTRutner Stephen M · Palm City, FLS/N E-2979 N600DCHerron Aviation Group LLC · Dexter, MIS/N 421C1007 N600EAEstancia Aviation LLC · Reno, NVBuilt 1985 · S/N S5500015 N600GDAlpha Mike LLC · Stoughton, MAS/N E3561 N600GKAerospace Trust Management LLC · Wilmington, DEBuilt 1998 · S/N 525-0297 N600HMFarm And Harvest Machinery LLC · Del Mar, CABuilt 1995 · S/N 208B0479 N600HPKansas Highway Patrol · Topeka, KSBuilt 2023 · S/N 208B5764 N600HRLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1993 · S/N 525-0038 N600JBOgden Aviation LLC · Hinsdale, ILBuilt 1998 · S/N 272 N600KEJuliet Zulu Aviation LLC · Loganville, GABuilt 1985 · S/N 416 N600LYMajjec Jhett LLC · Springfield, MABuilt 2004 · S/N 337 N600MSInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N E-995 N600NYNxjets.Net LLC · Wilmington, DEFirst renewal noticeBuilt 1978 · S/N 231 N600RKLc Whitford Co Inc · Wellsville, NYBuilt 2002 · S/N BB-1800 N600RVAero-Tech Services Inc · Lititz, PABuilt 1998 · S/N TH-1854 N600TGT & T Capital Inc · Bangor, MEBuilt 1993 · S/N 208B0363 N600VMLeisure Time Properties Inc · Ardmore, OKBuilt 2013 · S/N 525-0804 N600WADothan Security Inc · Dothan, ALBuilt 1980 · S/N LA-71 N600XTEubel Brady & Suttman Asset Management Inc · Miamisburg, OHBuilt 2009 · S/N 525-0375 N600ZZGsair Inc · Wilmington, DEBuilt 1973 · S/N E-400 N60125Tvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2009 · S/N FL-645 N601CWFree Bird Aviation LLC · Ridgeland, MSBuilt 1981 · S/N BB-842 N601DMR & G Aviation LLC · Hazlehurst, GABuilt 1979 · S/N LJ825 N601EFTextron Aviation Inc · Wichita, KSS/N 208B6001 N601JYRace Coast Aviation LLC · Port Orange, FLS/N 5010072 N601SWDynaero LLC · South Vineland, NJBuilt 1976 · S/N E904 N6023QCr Mcdowell Construction Co Inc · Keokuk, IABuilt 1979 · S/N E-1441 N6023UHigh Scott · Albuquerque, NMBuilt 1979 · S/N E-1442 N6023ZSchmauderer Ivan K · Woodland, CABuilt 1979 · S/N E-1468 N6024ZProag Services Inc · Mahnomen, MNBuilt 1979 · S/N E-1447 N6025RScott James C · Akron, OHS/N E-1444 N60268Rougher Aviation LLC · Council Hill, OKBuilt 1979 · S/N E-1452 N6026YWestern Flying Club Inc · Burlington, NCBuilt 1979 · S/N E-1451 N6027UKolesar Mark A · Golden Valley, MNBuilt 1979 · S/N E-1457 N6028EChiappe Glenn R · Lago Vista, TXBuilt 1979 · S/N E-1458 N602DCKeystone Xpress LLC · Rostraver Twp, PAS/N 421C0864 N602DH2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 1973 · S/N LW-44 N602EFTextron Aviation Inc · Wichita, KSS/N 208B6002

Back to AD 2006-16-18 R1