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.

N6207FAir New England LLC · Portsmouth, NHBuilt 1982 · S/N LJ-1017 N620BBShore Brian E · Oyster Bay, NYBuilt 2001 · S/N 525-0467 N620DGHallman Michael · Pine Bluff, ARS/N E-3435 N620TCRah Stockton Properties LLC · San Jose, CABuilt 1993 · S/N 525-0014 N620TWStrega Ventures LLC · Boca Raton, FLBuilt 1974 · S/N LW-107 N620VGKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2019 · S/N FL-1172 N620WESouthwest Aviation Inc · Marshall, MNBuilt 1977 · S/N LJ-743 N620ZSix Twenty Zulu Aviation LLC · Wilmington, DEBuilt 1973 · S/N TH-385 N621AFBright Skies Mt LLC · Kalispell, MTBuilt 1978 · S/N BB-331 N621AXBc Aircraft Leasing LLC · Albuquerque, NMS/N 48319 N621DEDesert Excavating Inc · Yuma, AZBuilt 2002 · S/N TH-2032 N621EMN621em LLC · Ocala, FLBuilt 1981 · S/N LA-123 N621GZHfjw Properties Leasing LLC · Santa Rosa Beach, FLBuilt 1998 · S/N FL-197 N621JAAircraft Partner Holdings Inc Trustee · BerlinBuilt 2014 · S/N 525-0857 N621JGWhite Aviation LLC · Ashford, ALBuilt 1981 · S/N BB-834 N621KBRjh Management LLC · Salem, ORBuilt 2022 · S/N 525-1130 N621KTDdm Aviation LLC · Coral Gables, FLBuilt 2021 · S/N 20800674 N621NMAirmorgan Limited LLC · Reno, NVBuilt 1974 · S/N TH-422 N621RHSchiffer Herbert · West Chester, PABuilt 1991 · S/N E-2654 N621SBHundredfold Seraphim LLC · Miami Lakes, FLBuilt 2001 · S/N 258531 N622ASAlaska Airlines Inc · Seattle, WABuilt 2000 · S/N 30165 N622KMK & M Equipment Co LLC · Chatsworth, CABuilt 1981 · S/N BB-491 N622PMChoice Aviation LLC · San Antonio, TXBuilt 1993 · S/N 650-7027 N622SLCommander Properties Inc · Wilmington, DEBuilt 2006 · S/N 525-0622 N622TFN9cr LLC · Hilton Head Island, SCBuilt 2002 · S/N 560-0622 N622TPPine Cove Lift LLC · East Haven, CTBuilt 2017 · S/N 208B5345 N622TRL C A Inc · Alamo, CABuilt 1980 · S/N 421C0858 N6231AEtzelmiller Arjay J · Lincoln, NEBuilt 1981 · S/N E-1983 N6232VWallace John B · San Carlos, CABuilt 1968 · S/N E-4 N6233GFlying Cardinals Aircraft Group Inc · Stow, MABuilt 1981 · S/N E-1984 N6233XRdm Ventures LLC · Buckhead, GABuilt 1982 · S/N E-1988 N6234ZBruce Bullock · West End, NCBuilt 1981 · S/N E-1985 N6236VIngraham Randy · Colbert, WABuilt 1968 · S/N E-1 N62379Sullivans Island Aerospace LLC · Sullivans Island, SCBuilt 1982 · S/N E-2007 N623BGRrkj Aviation LLC · Cave Springs, ARBuilt 1986 · S/N S550-0105 N623PMLal Holdings LLC · Gallatin, TNBuilt 1992 · S/N 650-7018 N623VTTextron Aviation Inc · Wichita, KSS/N 208B5992 N624ALUnderhill Holdings LLC · East Haven, CTBuilt 2006 · S/N 208B1183 N624JRPlane5 LLC · Fort Lauderdale, FLBuilt 2021 · S/N 208B5649 N624PWK3m Leasing LLC · Tyler, TXBuilt 2008 · S/N 560-0792 N624TELenbob Aviation LLC · Southaven, MSS/N TH-1588 N6254NCoil Construction Inc · Columbia, MOBuilt 1981 · S/N E-1989 N6255BRogers Aeronautics LLC · Lake Barrington, ILBuilt 1981 · S/N E-1990 N6255JAzimuth Aviation LLC · Mechanicsburg, PABuilt 1996 · S/N E-3019 N625ACAir Fiber LLC · Black Rock, ARBuilt 1994 · S/N 5600251 N625ASAlaska Airlines Inc · Seatac, WABuilt 2001 · S/N 30792 N625BWTechnology Service Corp · Arlington, VABuilt 1982 · S/N BB1090 N625HWBsw Acceptance Inc · Muleshoe, TXBuilt 1993 · S/N TH-1694 N625MOverbeek Michael F · Holland, MIBuilt 1974 · S/N TH-434 N625PGN625pg Corp Trustee · Wilmington, DEBuilt 1998 · S/N 525-0282

Back to AD 2006-16-18 R1