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.

N2334WBlazek James T · Malta, ILBuilt 1997 · S/N E-3134 N2335KBflyin LLC · Scottsdale, AZBuilt 1997 · S/N E-3135 N2335RPropellerhead Aviation LLC · Santa Cruz, CABuilt 1997 · S/N TH-1835 N2336MHerd James L · Gardnerville, NVBuilt 1997 · S/N E-3136 N2337TPate Jason L · Bedford, TXBuilt 1997 · S/N E-3137 N233CKAllen Max · Jefferson, GABuilt 1977 · S/N E-1014 N233CTHoneycutt Danny · Angier, NCBuilt 1984 · S/N TH-1433 N233JKLcr Aviation LLC · Richland, WABuilt 2008 · S/N 560-0797 N233PCWright Air Service Inc · Fairbanks, AKBuilt 2006 · S/N 208B1179 N2340APommersheim John Mark · Dulles, VAS/N E-3182 N2343XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 208B2343 N2345WHanisch Paul J · Crosby, NDBuilt 1998 · S/N E-3188 N2347GSmith Steven L · Whitehall, MTBuilt 1998 · S/N TH-1867 N2347VSomes Jason S · Santa Rosa Valley, CABuilt 1998 · S/N E-3147 N2348QLegha Jaskirat · Holly Ridge, NCBuilt 1998 · S/N TH-1848 N2349SAjs Aviation LLC · Warroad, MNS/N 421C1209 N234AQDavis Lee Enterprises LLC · Guntersville, ALBuilt 1993 · S/N 560-0234 N234KW405 Transportation Partners LLC · Edmond, OKBuilt 1982 · S/N BB-1065 N234LRDanish Jet Inc Trustee · Cheyenne, WYBuilt 1980 · S/N 300 N234WLGalaxy Sea Lift LLC · New York, NYS/N 208B5794 N234WMBay Area Skymaster LLC · Pasadena, MDBuilt 1962 · S/N 500A-1257-81 N23523Fox & Bear Air Charters LLC · South Padre Island, TXBuilt 1977 · S/N E-1175 N23524San Francisco Peaks Trucking Inc · Flagstaff, AZBuilt 1978 · S/N E-1174 N2352YMilton Jerry D · Lillington, NCBuilt 1998 · S/N TH-1865 N23540State Of Iowa · Iowa City, IABuilt 1977 · S/N E-1180 N23541Registration Pending · Middleburg, FLRegistration pendingBuilt 1977 · S/N E-1182 N2354FBarbee William Terry · Weslaco, TXBuilt 1998 · S/N E-3154 N2354YUtah Department Of Transportation · Salt Lake City, UTBuilt 1998 · S/N LJ-1532 N23551S&M Aviation (A Co Limited Liability Co) · Colorado Springs, COBuilt 1977 · S/N E-1183 N2355TBe-3195 LLC · Conway, ARBuilt 1998 · S/N E-3195 N23578Green Law Aviation Inc · Culpeper, VABuilt 1977 · S/N E-1185 N2357NCreviston Steven Eric · Greensboro, NCBuilt 1998 · S/N E-3157 N23589High Times Adventure Co LLC · Columbiana, ALBuilt 1977 · S/N TH-889 N2358KSmith Aeromotive Charters Inc · Excelsior, MNBuilt 1997 · S/N TH-1827 N2359LJ & M Baling Inc · Farmington, NMBuilt 1998 · S/N E-3159 N235LCRosado Aviation Inc · Moosic, PABuilt 1996 · S/N BB1535 N235SEPlane Flt LLC · Broken Arrow, OKBuilt 1981 · S/N E-1953 N235SGZonaair LLC · Roll, AZS/N E-3544 N235SMTriniair LLC · Warner Robins, GAS/N TH-926 N235ULAircraft Endeavors LLC · San Antonio, TXBuilt 1976 · S/N 46956 N23608Beech36 LLC · Clarkston, MIBuilt 1978 · S/N E-1188 N23615Yoder Metal & Post Frame & Building Supplies · Haven, KSBuilt 1977 · S/N E-1191 N23620Erickson Brian C · Pahrump, NVBuilt 1977 · S/N E-1165 N23621Excellance Inc · Madison, ALBuilt 1977 · S/N E-1192 N23639Teleprint Inc · Rydal, PABuilt 1978 · S/N E-1293 N23682Next Century Aviation Oregon LLC · Sausalito, CABuilt 1978 · S/N E-1205 N236AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36351 N236BEMcgill Benjamin D · Larchmont, NYBuilt 1981 · S/N E-1825 N236CHGta Air Inc · Addison, TXBuilt 1973 · S/N E-502 N236CPArtic Legacy Aviation LLC · Anchorage, AKBuilt 1976 · S/N BE-9

Back to AD 2006-16-18 R1