OpenAirDocs.org
AD 81-18-04 R2

Registered aircraft · 81,728

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
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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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.

N269JLPeecher Carl J · Sequim, WAS/N 5020N269JPBrones Jon P · Blanco, TXBuilt 1977 · S/N 670611N269KGMvt Aviation LLC · Magnolia, TXBuilt 2013 · S/N CH402N269KMParagon Airplane Leasing Co · Fort Myers, FLBuilt 2022 · S/N 28020099N269MAOrange Wing Aviation Inc · Wilmington, DES/N 1361-2004N269MDCactus Air Force LLC · Carson City, NVBuilt 1963 · S/N 33-0175N269MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881367N269MRAgl LLC · Othello, WABuilt 1997 · S/N S1753N269NInternational Air Services Inc Trustee · Carson City, NVBuilt 1987 · S/N S 1267N269NEOro LLC · Tilden, NES/N 17272505N269PBHmw LLC · La Grange, NCBuilt 1978 · S/N R18200546N269PEEnstrom Helicopter Corp · Menominee, MIBuilt 2024 · S/N 2176N269RHUnterreiner Dean · Prince George, VABuilt 1994 · S/N 20046N269RTTodd Jon R · Georgetown, CABuilt 2010 · S/N 72891N269RVHershey Lester E · Amelia Court House, VABuilt 2007 · S/N 90246N269SFlightco Inc · Swainsboro, GABuilt 2001 · S/N 18281061N269SAAlthof Equipment Management LLC · Jupiter, FLBuilt 2011 · S/N 18282280N269SFHarvey Kandace · Snohomish, WABuilt 1979 · S/N 690795N269STSalina Tree Inc · Salina, KSBuilt 1965 · S/N 85-0363N269TCleveland Frank W · Quinhagak, AKBuilt 1953 · S/N 18-2383N269TCRegistration Pending · Redmond, WARegistration pending, pending cancellationBuilt 1999 · S/N S1776N269TJSenninger Thomas P · Clermont, FLBuilt 2000 · S/N S1807N269TPPhoenix Leasing LLC · Menomonee Falls, WIBuilt 2000 · S/N 0110N269TTSharmark LLC · Dry Ridge, KYBuilt 1978 · S/N 680695N269TUAero Quest LLC · Olive Branch, MSS/N ME-95N269UAg-Av8r Flying Services LLC · Brookline, NHS/N WS298001N269VCRegistered aircraftBuilt 1992 · S/N S1609N269VTQualitair LLC Trustee · MichelstadtBuilt 1986 · S/N S 1229N269WFThomas Wilmer C · Fairbanks, AKBuilt 1999 · S/N 30007CN269WMRenninger Log Homes · Meeker, COBuilt 1959 · S/N 18-6874N269WYBailey Raymond J · Mansfield, TXBuilt 2016 · S/N 3269N269YEyles Richard L · Galloway, OHBuilt 1965 · S/N 30-798N269YADavenport Ross K · Raleigh, NCBuilt 1994 · S/N RV-6-21606N269ZZKaplan Richard P · Cape Coral, FLS/N 866N26AAMustang Sally Aviation LLC · Camden, SCBuilt 2016 · S/N 172S11693N26ACWater Wheel Aviation · Middletown, DEBuilt 1954 · S/N 54-2359N26ADTango Aviation LLC · Valrico, FLS/N 20264N26AESwallows Inc · San Jose, CABuilt 1976 · S/N 230(2106)N26AFTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1983 · S/N 6N26AJByford Christopher H · Mc Gregor, TXBuilt 2005 · S/N 90444N26AKLousberg Daniel A · Wasilla, AKBuilt 1974 · S/N 18-7409079N26AUMaximum Entropy Inc · Wilmington, DEBuilt 1979 · S/N 282 (37-002)N26BMRegistered aircraftBuilt 1999 · S/N 18280659N26BQAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13219N26BWBestul Greg · Lester Prairie, MNBuilt 1967 · S/N 30-1559N26BYSnohoacro LLC · Mukilteo, WABuilt 2004 · S/N 963-2004N26CARogers Patricia A · Albany, ORBuilt 1979 · S/N 15283794N26CLPuckett Lewis R · Ellijay, GABuilt 1973 · S/N CL72N26CMLaurel Highlands Aeronautical Academy · Latrobe, PABuilt 1958 · S/N TD-119N26CWBarzelatto Brett · Thornton, COS/N 17272496
Back to AD 81-18-04 R2