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.

N78DBGreenbrier Aviation LLC · Sevierville, TNBuilt 1980 · S/N TH-1152 N78GWCbs Aviation LLC · Jackson, MSBuilt 1978 · S/N E-1351 N78KGClayton Donald D · Sugar Land, TXBuilt 1975 · S/N E-643 N78KLNea Industrial LLC · Paragould, ARBuilt 1990 · S/N TH-1578 N78QRQrp Air LLC · Quincy, ILBuilt 2004 · S/N LJ-1699 N78REKhg Aircraft Inc · Peachtree City, GAS/N TH-371 N78SAMartinaire Aviation LLC · Addison, TXBuilt 1995 · S/N 208B0467 N78SVBba Aviation LLC · Raleigh, NCBuilt 1997 · S/N LJ-1504 N78TJKcs Aviation LLC · Columbia, TNBuilt 2015 · S/N 525-0864 N78VCBb58 LLC · Greenville, MSBuilt 1995 · S/N TH-1743 N78WCPro Equine Group Management LLC · Garland, TXBuilt 2016 · S/N FL-1079 N78WWPark Avenue Group Inc · Stuart, FLBuilt 1995 · S/N TH-1747 N79Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-14 N7905RFlaherty Ryan J · Scottsdale, AZBuilt 1970 · S/N E-230 N790AWilliam C New Aviation Services LLC · Morgan City, LABuilt 1982 · S/N LJ-1016 N790ALAngels Envy Aviation LLC · Denison, TXBuilt 1985 · S/N S550-0024 N790FEFederal Express Corporation · Memphis, TNBuilt 1991 · S/N 208B0288 N7916RHealy David Paul · Arlington, TXBuilt 1969 · S/N E-140 N791AABonanza Paradise LLC · Queen Creek, AZBuilt 1979 · S/N E-1609 N791DCExecutive Air Taxi Corporation · Bismarck, NDBuilt 1991 · S/N BB-1402 N791EBSav Aviation LLC · Jacksonville, TXBuilt 1980 · S/N BB791 N791JFUS Trinity Equipment LLC · Argyle, TXBuilt 1978 · S/N 501-0079 N7920MWirt John P · Lake Havasu City, AZBuilt 1980 · S/N E-1714 N79279United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31597 N792FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0290 N792JHElgee Aviation LLC · Fairfield, NJBuilt 2001 · S/N TH-1988 N7931DJet Air Inc · Galesburg, ILBuilt 1982 · S/N LJ-1049 N7934RLa Playa LLC · Wilmington, DEBuilt 1969 · S/N E-142 N7936ABb Air Guys LLC · Scott City, KSBuilt 1978 · S/N E-1421 N793AAMch Aviation LLC · Chapin, SCBuilt 1979 · S/N 501-0106 N793ACUmb Bank Na Trustee · Salt Lake City, UTS/N 30734 N793BCFour Lee LLC · Jeffersonville, INBuilt 2007 · S/N 560-0758 N793CJAgl Lease LLC · Grand Rapids, MNBuilt 2000 · S/N 525-0021 N793DCBillings Clinic · Billings, MTBuilt 1991 · S/N BB-1404 N793FSWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N FL-793 N793RCLfg Aviation Holdings LLC · Kalispell, MTBuilt 2001 · S/N 258550 N79402United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30119 N794AJZero Gravity Corp · Merritt Island, FLBuilt 1976 · S/N 21243 N794FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0292 N794PFPrestage Farms Of South Carolina LLC · Camden, SCBuilt 2007 · S/N 525-0649 N794UTUniversity Of Tennessee · Alcoa, TNBuilt 2008 · S/N FL-576 N7951RWilley Rick E · Hendersonville, TNBuilt 1969 · S/N E-145 N79521United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31662 N79541United Airlines Inc · Chicago, ILBuilt 2017 · S/N 63725 N7958DNewcomb Clint M · Benton, ARS/N TH-1019 N795ABSilver Mar LLC · Key Biscayne, FLBuilt 1998 · S/N TH-1880 N795FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0293 N795FMCypress Aircraft Sales LLC · Clermont, FLS/N 228 N795JGrant Aviation Inc · Anchorage, AKBuilt 2019 · S/N 208B5550 N795PAPdx LLC · Indianapolis, INS/N BB-328

Back to AD 2006-16-18 R1