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.

N3306VHart Aviation LLC · Emory, TXS/N D-765 N3307VAgogi Learning Systems LLC · Dahlonega, GABuilt 1947 · S/N D-766 N3308VRobb Steven G · Riverside, CABuilt 1947 · S/N D-767 N3309VArjad Henry · Irvine, CAS/N D-768 N330AEBank Of Utah Trustee · Salt Lake City, UTS/N 33007 N330DBBlueskyways LLC · Bend, ORBuilt 1999 · S/N LJ-1542 N330GTStaub Gerald J · Tavernier, FLBuilt 1986 · S/N E-2349 N330VAlcovy Mountain Venture LLC · Monroe, GABuilt 1978 · S/N LJ-811 N330VPJ & N Leasing LLC · Spokane, WABuilt 1995 · S/N 560-0330 N3317VMathews Thomas R · Indianapolis, INBuilt 1947 · S/N D-777 N331AAAsher Aviation Group LLC · Durango, COBuilt 1989 · S/N 560-0008 N331BRBuffalo Bayou Air LLC · Houston, TXBuilt 1999 · S/N 560-0530 N331CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1986 · S/N 23747 N331GGGed Jet LLC · Boca Raton, FLBuilt 1999 · S/N 525-0353 N331GRTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2003 · S/N FL-381 N331MW331 Mike Whiskey LLC · Scottsbluff, NEBuilt 1996 · S/N 560-0384 N331RFRandigo LLC · Wilmington, DEBuilt 1999 · S/N 208B0754 N331SASunlight Aviation LLC · Anchorage, AKS/N E-3301 N331SKD & E Aviation LLC · Missoula, MTBuilt 1992 · S/N 063 N33203United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30613 N33209United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30581 N3320VFricke Albert G · Lomita, CABuilt 1947 · S/N D-780 N3321CAviation Management II LLC · Des Moines, IAS/N E-1261 N33262United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32402 N33264United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31584 N33266United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32403 N33284Umb Bank Na Trustee · Salt Lake City, UTBuilt 2004 · S/N 31635 N33286United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31600 N33289United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31607 N33292United Airlines Inc · Chicago, ILBuilt 2004 · S/N 33455 N33294Wells Fargo Trust Co Na Trustee · Columbia, MDBuilt 2005 · S/N 34000 N3329VMcmahon Jeffrey J · Paris, KYFirst renewal noticeBuilt 1947 · S/N D-790 N332CAPhysicians Air Transport LLC · Hot Springs, ARBuilt 1981 · S/N BB-816 N332CBFlying Pigs Aviation LLC · Los Altos, CABuilt 2000 · S/N E-3306 N332CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1987 · S/N 23707 N332DEMetro Aircraft Co · Bloomington, MNBuilt 1975 · S/N LJ-674 N332JSSouth Coast Lumber LLC · Brookings, ORBuilt 2006 · S/N BB-1938 N332MSLowcountry Aviation Company Brokerage LLC · Walterboro, SCBuilt 1982 · S/N LJ1023 N3330MMaine Instrument Flight · Augusta, MEBuilt 1979 · S/N TH-1031 N3332BAirkrapf LLC · Clearwater, FLBuilt 1997 · S/N E-3140 N3333AReese Ronald R · Lakewood Ranch, FLBuilt 1977 · S/N E970 N3333VBarreto David · Beavercreek, OHBuilt 1947 · S/N D-795 N3337VStrong Don E Jr · Milano, TXS/N D-799 N333AHAerotrust Services Corp Trustee · Wilmington, DEBuilt 1993 · S/N 650-0222 N333BENtn3n LLC · Titusville, FLBuilt 1960 · S/N 500A-979-33 N333HCN333hc LLC · Midland, TXBuilt 2000 · S/N FL-286 N333KEFalconmitch Inc · Sulphur Springs, TXBuilt 1974 · S/N 14 N333LDKickin Tires Aviation LLC · Lake Wales, FLS/N 20800530 N333PCSemanik Investment Corp · Jacksonville, FLBuilt 2004 · S/N 258669 N333QTQ Flight LLC · Bernardsville, NJBuilt 2000 · S/N BB-1702

Back to AD 2006-16-18 R1