Registered aircraft · 81,720

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: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

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.

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

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.

N18390Precision Design Inc · Wilmington, DES/N 21171 N1839EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12175 N1839TBluewater Airmotive Corp · Wilmington, DEBuilt 1971 · S/N 28-7125262 N183APennington Madison D · Oak Harbor, WABuilt 1985 · S/N SN-183 N183ACSynnes Mark A · Halliday, NDS/N 728-94 N183ASCorporate Helicopter Leasing · Dallas, TXBuilt 2000 · S/N 0827 N183BBRussell Charles B DBA · Union City, TNBuilt 1978 · S/N R18200310 N183CFCherokee Flyers Inc · Vero Beach, FLBuilt 1999 · S/N 2843232 N183CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282342 N183FCarter Christopher · Houston, MSBuilt 2025 · S/N 8-4135 N183FCPinnacle Medical Solutions LLC · New York, NYBuilt 2009 · S/N 90183 N183JRRausch John C · Upland, CABuilt 2009 · S/N 80110 N183LELeading Edge Flight Academy LLC · Bend, ORBuilt 2007 · S/N 4183 N183MACarpe Diem Montana Inc · Columbus, MTBuilt 2012 · S/N 3163 N183MERegistration Pending · Page, AZRegistration pendingBuilt 2000 · S/N 20608107 N183NWNorthwestern Michigan College · Traverse City, MIBuilt 2011 · S/N 172S11083 N183PSHc02 LLC · Vero Beach, FLBuilt 2014 · S/N 2328 N183RFBero Tim · Vernonia, ORBuilt 2002 · S/N 183R N183RLJe Air LLC · Bayamon, PRBuilt 1973 · S/N 17261654 N183SBBarnes Steven D · Santa Rosa, CAFirst renewal noticeBuilt 2005 · S/N 001 N183WOertel William R · Norco, CABuilt 1984 · S/N 1446 N1840GJulicher Mark R · Bulverde, TXBuilt 1968 · S/N 79 N1840Q6 Cs Air Inc · Tacoma, WABuilt 1971 · S/N 177RG0240 N1840VUnited States Air Force Owner · Apo, APBuilt 1974 · S/N 17263767 N18414US Aviation Training Solutions · Titusville, FLBuilt 2005 · S/N 0226 N1841AJohnson Kevin L · Canyon, TXBuilt 1952 · S/N 18-1735 N1841QEvolution Electronics LLC · Superior, WIBuilt 1972 · S/N 177RG0241 N1842EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12176 N1842GOwen Dean W · Morehead, KYBuilt 1968 · S/N 585 N1842JAgthe Thilo Claus · Highlands, NJBuilt 1968 · S/N 28-24277 N1842QKrause Douglas S · Davis, CABuilt 1971 · S/N 177RG0242 N1842TPowell Gary · South Jordan, UTBuilt 1971 · S/N 28-7125273 N1843GWincar Air LLC · Doniphan, NEBuilt 1968 · S/N 78 N1843JMerlina Michael · North Reading, MABuilt 1968 · S/N 28-24278 N1843PAdams James · Quinlan, TXBuilt 1955 · S/N 22-2623 N1843QJohnson Dana J · Winona, MNBuilt 1972 · S/N 177RG0243 N1843TWalko Timothy A · Florence, MAS/N 28-7105117 N1844GTwenty One Miles LLC · Woodland Hills, CABuilt 1968 · S/N 84 N1844JSwanberg Brian M · Federal Way, WABuilt 1968 · S/N 28-24279 N1844QT & E Brothers Inc · Gardena, CABuilt 1972 · S/N 177RG0244 N1845VSkypark Inc · Wadsworth, OHBuilt 1974 · S/N 17263769 N1846PGrumpy Aviation Ltd · Denver, COBuilt 1955 · S/N 22-2628 N1846QBucciarelli Tazio E · San Diego, CABuilt 1972 · S/N 177RG0246 N1846TSatern Tate P · Dakota City, IABuilt 1971 · S/N 28-7105119 N1847GRogers Joe E · Manvel, TXBuilt 1968 · S/N 91 N1847JMehrle Properties LLC · Mcclure, ILBuilt 1968 · S/N 28-24283 N1847QDye Michael M · Bastrop, TXBuilt 1972 · S/N 177RG0247 N1847TMayer Joseph J · Rolling Meadows, ILBuilt 1971 · S/N 28-7105120 N1848JFrozen Aero Enteprises LLC · Grand Forks, NDBuilt 1968 · S/N 28-24284 N1848NMeserve Guy S · Sandpoint, IDBuilt 1982 · S/N WA-312

Back to AD 81-18-04 R2