AD 81-18-04 R2

Registered aircraft · 81,733

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.

N55144Bell Air LLC · Las Cruces, NMBuilt 1981 · S/N 17275118N55146Sky High Aviation LLC · Gonzales, LABuilt 1981 · S/N 17275119N55148Lierle Sidney D · Clearlake, CABuilt 1973 · S/N 28-7325333N55149County 17 Aviators LLC · Gillette, WYS/N 28-7325334N5514FWingrove Rodney W · Vincent, OHBuilt 1968 · S/N 28-24856N5514LFlight School Of Gwinnett Inc · Lawrenceville, GAS/N 15284327N5514MPruitt Buster Jr · Shelbyville, TNBuilt 1967 · S/N 113N5514PCohran Enterprise LLC · Pineville, LABuilt 1958 · S/N 24-577N5514QKurtz Hans E · Clewiston, FLBuilt 1965 · S/N 610N5514UCheckers Investments Inc · Edmond, OKBuilt 1969 · S/N 28-26226N5514ZWilkinson Bruce O · Williamsburg, VABuilt 1962 · S/N 22-9301N55150Alexander Dennis K · Gallatin, TNBuilt 1973 · S/N 28-7305322N55151Learn 2 Fly LLC · Cantonment, FLBuilt 1973 · S/N 28-7415001N55154Kanpahem Aviation LLC · Hawkins, TXBuilt 1973 · S/N 28R-7335187N5515LDoody Michael C · Knoxville, TNBuilt 2003 · S/N 18060CN5515MBarringer William R · Benbrook, TXBuilt 1967 · S/N 140N5515QLassiter Bobby L · Newport, ARBuilt 1981 · S/N 15285115N5515SGotay Ricardo M · Watertown, CTBuilt 2003 · S/N 33004CN5515VMt Aircraft LLC · Port Orange, FLS/N 30023CN5515ZLandrum Kelly T · Halifax, VABuilt 1962 · S/N 22-9302N55160Davis Joseph S · Andalusia, ALBuilt 1981 · S/N 17275123N55163Jackson Donald W · Carthage, MSBuilt 1973 · S/N 28-7325335N55166Volando LLC · Columbia, MOBuilt 1973 · S/N 28-7325338N55167Flyboys Nevada LLC · Henderson, NVBuilt 1973 · S/N 28-7305325N55169Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275126N5516FMoore Marcus · Auburn, ALS/N 28-24858N5516JRobarge Andrew Michael · Crown Point, INBuilt 1967 · S/N 32-925N5516LBarnes Richard A · Federal Way, WABuilt 1980 · S/N 15284329N5516SAtc Trucking Inc · Miami, FLBuilt 2003 · S/N 28016CN5516UHicks David A · Beaver Dam, WIBuilt 1969 · S/N 28-26228N55173Dareing Chon · San Antonio, TXBuilt 1973 · S/N 28-7305327N55176Hall Davis · Mobile, ALBuilt 1973 · S/N 28R-7335189N55177Saunders Ivan J · Margate, FLBuilt 1973 · S/N 28R-7335190N55179Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17275128N5517FMccarthy Mark C · Russellville, ARS/N 28-24859N5517JGiblin Daniel P · Loveland, OHBuilt 1967 · S/N 32-949N5517KCarter Brantley F · Timmonsville, SCBuilt 1978 · S/N 1253-78N5517MBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 10A-033N5517PVoorhees Kenneth J · Aiea, HIBuilt 1981 · S/N 15284963N5517QTrayhan Edward J · Schertz, TXBuilt 1965 · S/N 2947N5517VWest Bryan M · Heath, TXS/N 28-26230N5517ZTravnicek Sandy R · Bowie, TXBuilt 2002 · S/N 25085CN5518Campbell Larry L · Fort Mill, SCBuilt 2008 · S/N 1376N55181Bluewater Airmotive Corp · Wilmington, DEBuilt 1973 · S/N 34-7350181N55182Sofla Sky Solutions LLC · Deerfield Beach, FLS/N 17275129N55185Bailey Richard W · Auburn, ALBuilt 1973 · S/N 28-7305329N55187Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1981 · S/N 17275131N5518GChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11391N5518JEbaugh Michael D · Port Saint Lucie, FLBuilt 1967 · S/N 32-952N5518KDiaz James F · Campbell, CAS/N 1024-78
Back to AD 81-18-04 R2