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.

N28ELDodson International Parts Inc · Rantoul, KSS/N FA-144 N28FDPacific Air Center LLC · Long Beach, CABuilt 2014 · S/N 525-0822 N28KAJames John · Bennett, COBuilt 2003 · S/N FL-377 N28KMN28km LLC · Wilmington, NCBuilt 1983 · S/N BB-1159 N28KPState Of Montana · Helena, MTBuilt 1979 · S/N LJ-845 N28MGHudson Equipment LLC · Camden, DEBuilt 1988 · S/N TH-1535 N28QAHuff Air LLC · Uvalde, TXBuilt 1997 · S/N 5250215 N28RHNational Airplane Sales & Leasing Corp · Lima, OHBuilt 1980 · S/N 421C0847 N28RKRd Aviation Lp · Redlands, CABuilt 1995 · S/N 525-0111 N28TXMidwest Flying Service Dos LLC · Sheldon, IABuilt 1992 · S/N 650-7007 N28VRPajaro 195 LLC · Fort Worth, TXBuilt 1996 · S/N BB-1540 N28VUPhysicians Air Transport LLC · Hot Springs, ARBuilt 1980 · S/N BB-743 N28WCMoorad Sports Partners LLC · Newport Beach, CABuilt 2017 · S/N FL-1097 N28WDOptio Air LLC · Moore, OKS/N 421C0715 N28ZFCore Projects Inc · Fresno, CAS/N NA0458 N2901LStraight & Level Aviation LLC · Bradenton, FLBuilt 1980 · S/N TH-1172 N2904Registered aircraftBuilt 1977 · S/N 501-0036 N290AKAlaska Airlines Inc · Seattle, WABuilt 2018 · S/N 64300 N290FAUmb Bank N A Trustee · Salt Lake City, UTS/N 29080 N290KAir Ems Inc · Tulsa, OKBuilt 1980 · S/N LW-337 N290KAN290ka LLC · Clare, MIBuilt 1974 · S/N LW59 N290NCMr Boo Properties LLC · Indianapolis, INBuilt 1987 · S/N LJ1158 N290PASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N LJ-519 N290SGinter Aviation LLC · Oakland, MDBuilt 1971 · S/N E-292 N2915BRobble Group LLC · Center Valley, PABuilt 1986 · S/N E-2314 N291ANKb Flies LLC · Amarillo, TXS/N 421C0242 N291ASLasai Aviation LLC · Reston, VABuilt 2001 · S/N FL-332 N291BBattelle Memorial Institute · Columbus, OHBuilt 2001 · S/N 317 N291CCMobile Ehr Inc · Argyle, TXBuilt 1977 · S/N LJ-728 N291DFRmb Leasing Inc · Dover, DEBuilt 1998 · S/N LJ-1534 N291PANorthrop Grumman Systems Corp · El Segundo, CABuilt 1977 · S/N BB-291 N2923CColley Robert E · Jamestown, TNBuilt 1955 · S/N D-310 N2927VHereth Eric W · El Cajon, CAS/N D-311 N2929VEllis Donald D W · High Springs, FLBuilt 1947 · S/N D-313 N292AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 64301 N292BWSkyline Aviation Services LLC · Miramar, FLBuilt 2006 · S/N 20800403 N292MWGroth Greg · Cookeville, TNBuilt 1994 · S/N E-2862 N292SSSkydive Guam Inc · Barrigada, GUBuilt 2005 · S/N 208B1142 N292TGCrown Aviation LLC · Lawrence, KSBuilt 2011 · S/N FL-743 N293AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 64302 N293PWatkins Air LLC · Mountain Brk, ALBuilt 1990 · S/N 049 N294AKAlaska Airlines Inc · Seatac, WABuilt 2018 · S/N 64303 N294AMAeh Flying Inc · Cincinnati, OHBuilt 1985 · S/N E-2262 N294CWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N 525-0114 N294JSJs Jet Three LLC · Kinston, NCBuilt 2021 · S/N 208B5643 N294RTSouthland Equipment Services LLC · Cottondale, ALBuilt 1995 · S/N 560-0264 N294TTUncommon Solutions LLC · Hollis, NHBuilt 1984 · S/N LJ1098 N295DCHibiscus26 Inc Trustee · Wilmington, DEBuilt 2000 · S/N BB-1709 N295DS4f Managment LLC · Salem, ORBuilt 1994 · S/N 525-0091 N295MLCorning Companies LLC · Billings, MTBuilt 2019 · S/N 525-1043

Back to AD 2006-16-18 R1