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.

N704FUK&A Advisors LLC Trustee · Wilmington, DES/N NA0335 N704JMCnhi LLC · Montgomery, ALBuilt 1998 · S/N 258367 N704KMK & M Aircraft LLC · Granbury, TXS/N 501-0325 N704MDNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2004 · S/N 208B1076 N704RARyan Air Inc · Anchorage, AKBuilt 2024 · S/N 208B5814 N705BBMo-Az LLC · Saint Louis, MOBuilt 2006 · S/N 258765 N705FSHvl Construction Inc · Fresno, CABuilt 1994 · S/N E-2836 N705FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0425 N705GWFba Aviation LLC · Wildwood, FLBuilt 1991 · S/N TH-1631 N705JTRegistration Pending · North Salt Lake, UTRegistration pendingBuilt 2025 · S/N 208B5917 N705NCEagle Leasing Inc · Gaylord, MIBuilt 1975 · S/N TH-595 N705SPSealandsky LLC · Santa Fe, NMBuilt 1985 · S/N S550-0048 N706AAArcher Automotive Inc · Houston, TXBuilt 1981 · S/N 421C1075 N706NCGaylord Hangers LLC · Gaylord, MIBuilt 1975 · S/N 421C0037 N706PPaccar Inc · Seatac, WABuilt 2001 · S/N 312 N7070AGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 1985 · S/N S550-0068 N70715State Of Alaska · Anchorage, AKBuilt 1990 · S/N 20800182 N707AJRandy Goering Inc · Bend, ORBuilt 1979 · S/N E-1499 N707BMLft Properties LLC · Mayfield Heights, OHFirst renewal noticeBuilt 2005 · S/N 258730 N707CXV1vr LLC · Wilmington, DEBuilt 1988 · S/N 216 N707FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0427 N707HPegasus Adventures LLC · Port Alsworth, AKFirst renewal noticeBuilt 2018 · S/N 208B5447 N707HATailwinds Aero LLC · Dubuque, IAS/N 421C1044 N707JQPinnacle Aviation Group LLC · Wilmington, DEBuilt 2005 · S/N 258703 N707LAStowers Machinery Corp · Knoxville, TNBuilt 1993 · S/N TH-1685 N707PCSkylift Air LLC · Rocky River, OHS/N LJ1703 N707PWAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1980 · S/N TH-1106 N707RARyan Air Inc · Anchorage, AKBuilt 2014 · S/N 208B5120 N707TToth Michael · Wadsworth, OHBuilt 1976 · S/N E-861 N707TLCentral Virginia Aviation Inc · North Dinwiddie, VAS/N LW-173 N707TPRicker David · Conway, ARS/N 421C0271 N707WWgi Leasing Inc · Vancouver, WABuilt 2001 · S/N 560-0556 N707WFCannery Leasing Ltd · Friday Harbor, WABuilt 2014 · S/N 20800562 N707WGRegistered aircraftBuilt 1968 · S/N E-70 N707WLFlight Solutions LLC · Chesterfield, MOBuilt 1983 · S/N TH-1377 N707ZHawley Elizabeth B · Wichita Falls, TXBuilt 1981 · S/N E-1978 N7089NAir Controls Billings Inc · Billings, MTBuilt 1968 · S/N E-14 N708AAWorld Aviation Services LLC · Medley, FLBuilt 1981 · S/N 22465 N708DCTechnology Service Corp · Arlington, VAS/N FL-371 N708DGBravan Aviation · Fort Lauderdale, FLBuilt 1970 · S/N LJ-508 N708MAFlying Machines LLC · Grand Ledge, MIBuilt 1981 · S/N TH-1304 N708MBUmb Bank Na Trustee · Salt Lake City, UTBuilt 2001 · S/N 30878 N708PVPm Leasing Inc · Perris, CABuilt 1976 · S/N 489 N708RARyan Air Inc · Anchorage, AKBuilt 2020 · S/N 208B5606 N708RKJudith River Management LLC · Newark, DEBuilt 2012 · S/N FL-812 N708SSierra Pacific Airlines Inc · Tucson, AZBuilt 1995 · S/N 27424 N708WAltitude Aviation LLC · Missoula, MTBuilt 1985 · S/N E2269 N7092THidden Valley Aviation LLC · Denton, TXBuilt 1975 · S/N TH-664 N709EAAerolease LLC · Fargo, NDBuilt 1992 · S/N LJ-1309 N709FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0430

Back to AD 2006-16-18 R1