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.

N77Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-12 N7707RCondor 1 LLC · Jackson, TNBuilt 1968 · S/N E-100 N7709RBonanza Angels LLC · Springfield, VABuilt 1968 · S/N E-102 N770ABAgb Management Inc · Warrenton, VABuilt 1981 · S/N BE121 N770ALAviation Company Inc · Cheyenne, WYBuilt 1979 · S/N BB.77 N770CCTaughannock Aviation Corp · Ithaca, NYBuilt 2002 · S/N 258587 N770DReynolds Roger David · Key West, FLBuilt 1980 · S/N BE-90 N770FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0265 N770LAGulf Airbatics Ltd · Jennings, LABuilt 1974 · S/N TH-517 N770PMachin Susan M Trustee · Newport Coast, CABuilt 1975 · S/N E-749 N770VFGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1641 N770WTS&R Transportation I LLC · Wilmington, NCS/N BB-1925 N7710RBeechcraft Heritage Museum · Tullahoma, TNBuilt 1969 · S/N E-103 N771CWJ&R Aviation Holdings LLC · Tampa, FLBuilt 1978 · S/N BE-52 N771FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0267 N771FMCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 2002 · S/N 258591 N771HEN771he LLC · Hillsborough, NJBuilt 1986 · S/N E-2325 N771MAgs Leasing Services LLC · Shoreview, MNBuilt 1971 · S/N E-293 N771MGEaglemed LLC · Wichita, KSBuilt 1998 · S/N BB-1636 N771NHeitzman Gordon E · White Bear Lake, MNBuilt 1947 · S/N D-1082 N771PADodson International Parts Inc · Rantoul, KSBuilt 1983 · S/N LJ-1055 N771PDGuardian Flight LLC · Lewisville, TXBuilt 2001 · S/N LJ-1635 N7724MFallonair Inc · Huntington, NYBuilt 1985 · S/N E2222 N77258United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30802 N77261United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31582 N77295United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34001 N77296United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34002 N772BABering Air Inc · Nome, AKBuilt 2017 · S/N 208B5416 N772CSH & D Aviation LLC · Smithfield, NCBuilt 2007 · S/N 560-0772 N772DBAtb Aviation LLC · Wilmington, DEBuilt 2000 · S/N E-3314 N772DDN36be LLC · Wilmington, DEBuilt 1993 · S/N E-2775 N772FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0268 N772HMHmhc Inc · Plymouth Meeting, PABuilt 2013 · S/N FL-900 N772HPWilmington Trust Co Trustee · Wilmington, DEBuilt 1999 · S/N FL-262 N772JBJsb Aviation LLC · Wichita Falls, TXBuilt 2001 · S/N LJ-1652 N773Uniquorne LLC · Helena, MTBuilt 1983 · S/N LA-214 N773CPDbs Aviation LLC · Wilmington, DEBuilt 1986 · S/N BB-1260 N773FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0269 N773PWTexair LLC · Hereford, TXBuilt 1979 · S/N LJ-864 N773RBPymp LLC · Nashville, TNBuilt 1990 · S/N 560-0052 N773SDSouth Dakota Department Of Transportation · Pierre, SDBuilt 1995 · S/N LJ1413 N773TPState Of Of Utah · Salt Lake City, UTBuilt 2000 · S/N BB-1722 N77430United Airlines Inc · Chicago, ILBuilt 2009 · S/N 37098 N77431United Airlines Inc · Chicago, ILBuilt 2009 · S/N 32833 N7744RStone John T · Columbia, MOBuilt 1968 · S/N E-105 N7745RCummings Thomas · Ventura, CABuilt 1968 · S/N E-107 N7747RD2 Aviation Services LLC · Wilmington, DEBuilt 1968 · S/N E-109 N774AKBering Air Inc · Nome, AKS/N BB-1797 N774ATN774at LLC · Leesburg, VABuilt 2008 · S/N 208B2012 N774BDDavis III Robert F · Longview, TXBuilt 1981 · S/N E-1868

Back to AD 2006-16-18 R1