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.

N260EABlue Sky Airfleet LLC · Kalispell, MTBuilt 2004 · S/N E-3408 N260RAUpward Aviation LLC · Tulsa, OKBuilt 1980 · S/N 421C1004 N260TTTri-State Generation & Transmission Association · Westminster, COBuilt 2020 · S/N FL-1243 N2613CThree Two Five Echo Fc · Corinth, TXBuilt 1985 · S/N E-2293 N2617URegistered aircraftSale reportedBuilt 1981 · S/N 501-0235 N261EABrownstone Aviation II LLC · Houston, TXBuilt 2001 · S/N E-3423 N261GBSafford Aviation Service Inc · Coolidge, AZBuilt 1985 · S/N LJ-1119 N261GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-261 N261MAMajestic Aviation LLC · Decatur, ALS/N LA-61 N261PJFly Pj LLC · New York, NYBuilt 2018 · S/N 208B5426 N261WRW.R. Meadows Inc · Hampshire, ILBuilt 1997 · S/N 560-0447 N26208United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30580 N26210United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28770 N26215United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28775 N26226United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28935 N26232United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28942 N262BKOmicron Business Services Inc · Winter Park, FLBuilt 1998 · S/N 525-0262 N262EAJeaps Aviation LLC · Edgewater, FLBuilt 2001 · S/N E-3417 N262MCAerospace Trust Management LLC Trustee · Wilmington, DES/N 421C0140 N262SPAluminum Eagle LLC · South Jordan, UTBuilt 1984 · S/N FA-33 N263AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 62471 N263BACreative Life LLC · St Pete Beach, FLBuilt 2001 · S/N FL-333 N263EAJdcwac LLC · Blair, NEBuilt 2002 · S/N E-3437 N263FBCrye-Leike South Inc · Memphis, TNBuilt 1998 · S/N 525-0263 N263HPCalifornia Highway Patrol · Mcclellan, CABuilt 2025 · S/N 20800719 N263LMVent Airlines Inc · Dover, DEBuilt 1994 · S/N 26603 N263SAColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1999 · S/N E-3283 N263SGAtlas Air Inc · Purchase, NYBuilt 1999 · S/N 29263 N263SNBlue Skies Hawker LLC · Whitefish, MTBuilt 2002 · S/N 258580 N2646PAlas De La Aguila LLC · Kalispell, MTS/N E-2313 N2648XN2648x Corp Trustee · Wilmington, DEBuilt 1979 · S/N 501-0105 N264AKAlaska Airlines Inc · Seatac, WABuilt 2016 · S/N 36360 N264DCAirdvm LLC · Rcho Sta Marg, CABuilt 1982 · S/N 421C1248 N264DEAircraft Endeavors LLC · San Antonio, TXBuilt 1978 · S/N 46985 N264GVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 650-0104 N264JGSparkling Diamond LLC · Middleton, WIBuilt 1999 · S/N E3264 N264KPKalinin Partners LLC · Juneau, AKBuilt 2004 · S/N 20800383 N264PARisk Assumption LLC · Horseshoe Bay, TXBuilt 1980 · S/N BE-86 N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327 N264SVBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 208B0462 N264SWBuilding Materials Supply Inc · Yakima, WABuilt 1998 · S/N E-3190 N264TSFoxtrot Aviation Services LLC · Canton, OHBuilt 1977 · S/N BE-24 N26533Txoperation LLC · Fort Scott, KSBuilt 1979 · S/N 421C0686 N2653M97 Lima LLC · Edina, MNBuilt 1986 · S/N E-2315 N26560Rockslide Analytics Inc · Livermore, CAS/N 421C0802 N2657BHughes Coby D · Collinsville, OKS/N 157 N2657GB & K Leasing Inc · Nantucket, MAS/N 421C0809 N2657NLoreto Aviation LLC · Wahoo, NES/N 421C0811 N26588Golden Aero LLC · Tarpon Springs, FLBuilt 1980 · S/N 421C0835 N2658ZVirtue Genetics LLC · Cedar Rapids, IAS/N 421C0827

Back to AD 2006-16-18 R1