Registered aircraft · 1,267

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:80-26-04-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:80-26-04-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:80-26-04-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:80-26-04-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:80-26-04-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:80-26-04-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.

N6944APacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954109 N6944YLg Aztec LLC · Boynton Beach, FLBuilt 1969 · S/N 27-4304 N694CRBravo Zulu Aviation Services LLC · Jacksonville, FLBuilt 1978 · S/N 27-7954011 N694JSHowell Renny P · Whitehouse, TXS/N 23-1571 N694PSSteger Paul M · Locust Grove, GAS/N 23-1732 N6952YPorterfield Brian B · Wasilla, AKBuilt 1969 · S/N 27-4316 N6955YN6955y LLC · Knoxville, IABuilt 1969 · S/N 27-4320 N6956YTolsma Michael J · Hawthorne, NJBuilt 1969 · S/N 27-4321 N696JANational Industrial Services LLC · Kingshill, VIBuilt 1965 · S/N 27-2924 N6970YBell Daniel E · Alexandria, KYBuilt 1969 · S/N 27-4337 N6971YNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1969 · S/N 27-4338 N698HNelson Bobby E · Naples, FLBuilt 1968 · S/N 27-4106 N6996AGrape Soda Adventures LLC · Weddington, NCBuilt 1979 · S/N 27-8054012 N69AJKolea Leasing LLC · Honolulu, HIBuilt 1966 · S/N 27-3112 N69FLFlx Holding Co LLC · Boca Raton, FLS/N 27-7654162 N6UCZborowski Ronald W · Eighty-Four, PABuilt 1975 · S/N 27-7554079 N6ZGTta Logistics LLC · Christiansted, VIBuilt 1968 · S/N 27-3872 N700YAlpha 678 LLC · Newark, DES/N 27-7754076 N701DMPacific Fleet Aviation LLC · Rochester, NYBuilt 1966 · S/N 27-3131 N702SPSportsmans Market Inc · Batavia, OHBuilt 1963 · S/N 27-2336 N703DPProfessional Aviation Group LLC · Wilmington, DES/N 27-3861 N7052HScruggs Ken · Galloway, OHBuilt 1975 · S/N 27-7554130 N705SFLet Industries LLC · Lewes, DEBuilt 1974 · S/N 27-7405311 N706SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 27-7405394 N70846Dc Aero LLC · Ramona, CABuilt 1971 · S/N 274593 N7091YJudie Bear Air LLC · Bend, ORS/N 23-4 N709HSRokaboka Ltd · Mount Ida, ARFirst renewal noticeS/N 27-3615 N70PBFreeman David B · Liberty, NCS/N 273146 N70TLAltitude Adjusters LLC · Cranford, NJBuilt 1965 · S/N 27-2797 N711KHDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-7954036 N712JTSkylens LLC · Hammond, LABuilt 1979 · S/N 27-7954057 N712TMHudson Valley Helicopter Flight Services LLC · Salt Point, NYBuilt 1979 · S/N 27-7954083 N713ECCharlie Tango LLC · Mechanicsville, VABuilt 1975 · S/N 27-7554151 N713VSJrr Professional Services LLC · Davie, FLBuilt 1974 · S/N 277405415 N717WSCutting Edge Sales LLC · Santa Fe, NMBuilt 1961 · S/N 27-415 N7181YEagle Aeronautics LLC · Chicago, ILS/N 27-8054021 N718MWescon Margin Inc · Wilmington, DEBuilt 1979 · S/N 27-8054011 N71FLWest Transportation LLC · West Bloomfield, MIBuilt 1968 · S/N 27-3969 N722JWMcintosh Kenneth V · Pleasant Plain, OHBuilt 1962 · S/N 27-2040 N724VSTwin Oaks L & A Ltd · Wilmington, DEBuilt 1957 · S/N 23-869 N72553Whittom Ron W Jr · Wasilla, AKS/N 23-1031 N727TCSandpiper Air LLC · Dickinson, TXBuilt 1976 · S/N 27-7654107 N7294PMcnamara Pa · Far Hills, NJBuilt 1978 · S/N 27-7854072 N730MCCpc2 Aviation LLC · Hoover, ALBuilt 1965 · S/N 27-3097 N73VPyle Dana · Naples, FLBuilt 1961 · S/N 23-2026 N73WHBumble Bee Aviation LLC · Brookfield, WIS/N 27-7305184 N74199Aldrich Curtiss R · Aguila, AZBuilt 1965 · S/N 27-3026 N7436CMatanane Roke C · Barrigada, GUBuilt 1976 · S/N 27-7754017 N747ATHaueisen Jessica · Franklin, GABuilt 1978 · S/N 27-7854080 N747WWN Registration Services LLC Trustee · Sanford, NCS/N 27-4330

Back to AD 80-26-04 R1