OpenAirDocs.org
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.

N50678Nieslanik Diane M · Cokeville, WYBuilt 1979 · S/N 1194-80N5067CMutter William D · Chelan, WABuilt 1979 · S/N 1333-80N5067GJones Jerry E · Pocahontas, ARBuilt 1979 · S/N 391-80N5067HSanders Flight Training Center Inc · Jasper, ALS/N 17265326N5067KN5067k LLC · Lenexa, KSBuilt 1979 · S/N 589-80N5067SSinatsch Christian C · Saint Augustine, FLS/N 28R-35810N5067VKampert Keith Wayne Jr · Ninety Six, SCS/N VAC55-76N5067WFiore Christopher · Forked River, NJBuilt 1961 · S/N 28-76N5067XMiller Johnny D · Rhome, TXS/N 150N5068DGeorge Delmond L · Dewitt, ARS/N 1195-80N5068GScaled Composites LLC · Mojave, CABuilt 1979 · S/N 602-80N5068KMcclung Matthew T · Avon, INBuilt 1979 · S/N 1338-80N5068LPark Jalynn C · Blacksville, WVBuilt 1979 · S/N 1196-80N5068TAbc Leasing Inc · Oakdale, LABuilt 1980 · S/N 1197-80N5068UCaywood Beauregard Janice E · Hollis, NHBuilt 1979 · S/N 1339-80N5068WJankord Emery T II · Ballston Lake, NYS/N 28-77N5068XNobles Ronny · Live Oak, FLBuilt 1968 · S/N 151N5068YFarnham Aviation Services LLC · Ames, IABuilt 1979 · S/N 1340-80N50693Griffing Flying Service Inc · Port Clinton, OHBuilt 1978 · S/N 828N5069FMunns Dana K · Diamondhead, MSBuilt 1980 · S/N 1341-80N5069GLeverich J E · Pampa, TXBuilt 1980 · S/N 1198-80N5069HNehring Curtis A · Goleta, CABuilt 1975 · S/N 17265327N5069SMccarron Michael · Cary, ILBuilt 1971 · S/N 28R-7135074N5069UGoff Bayou LLC · Shelby, MSS/N 612-80N5069VDieter Damian D · South Bend, INBuilt 1976 · S/N VAC-58-76N5069WNelson Stephen A · Milaca, MNBuilt 1961 · S/N 28-78N5069XWright Bruce M · Rosharon, TXBuilt 1968 · S/N 152N506ATClinthorne David W · Fredericksburg, VABuilt 2024 · S/N 22740N506CDAloha Helicopter Tours LLC · Lihue, HIBuilt 2008 · S/N 1976N506CERichards Robert F · Downers Grove, ILBuilt 2015 · S/N BR1N506CXEagle Helicopters LLC · Beulah, NDBuilt 2006 · S/N 11253N506DKolstad David L · Northridge, CABuilt 1982 · S/N 2027N506DBMerlin Labs Inc · Mojave, CABuilt 2008 · S/N 001N506DCCombs Dale B · Pleasant Grove, UTBuilt 1996 · S/N 001N506DEAero Fliers LLC · Kalispell, MTBuilt 1977 · S/N 15279717N506DSFlight Level 510 LLC · El Dorado Hills, CABuilt 2002 · S/N 40.206N506EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12857N506GLKutschera Theodore C III · Callicoon, NYBuilt 1973 · S/N 0506N506JMAims Community College · Greeley, COBuilt 2018 · S/N 4496432N506MRegistered aircraftBuilt 2007 · S/N 90137N506PCShettlesworth Ryan C · Bloomington, INBuilt 1992 · S/N 1465N506RBChristiansen Aviation LLC · Wilmington, DEBuilt 1997 · S/N 2843092N506RVMelillo Peter J · Huntington Station, NYBuilt 1997 · S/N 22717N506SPHenrie Aviation LLC · Fairfield, NJBuilt 2000 · S/N 172S8363N506XLyons Leasing LLC · Zionsville, INBuilt 2003 · S/N 3232002N506XCMark A Hall LLC · Sunman, INBuilt 2016 · S/N CC19-0004N5070GSky Fusion II LLC · Atlanta, GABuilt 1980 · S/N 640-80N5070LHayden Daniel · North Pole, AKBuilt 1978 · S/N 18-7809122N5070NWilkinson Dane W · Morgan, UTBuilt 1980 · S/N 614-80N5070UO'Donnell Paul E · Schuylerville, NYBuilt 1980 · S/N 615-80
Back to AD 81-18-04 R2