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

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.

N5271SRegistered aircraftBuilt 1980 · S/N R18201533 N5271TOracle Aviation LLC · Omaha, NEBuilt 1972 · S/N 28R-7235212 N5271U71 Uniform Corp · The Villages, FLBuilt 1980 · S/N 172RG0316 N5271WBrown Thrasher Aero LLC · Midland, GABuilt 1962 · S/N 28-317 N5271XRussell Steven N · Anchorage, AKBuilt 1969 · S/N 196 N5271ZElliot Kirk R · Tulsa, OKBuilt 1961 · S/N 22-8963 N52720Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274592 N52723Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 177RG1258 N5272AWelch Kevin R · Hartland, WIBuilt 1961 · S/N 23-2019 N5272KGarmin International Inc · Salem, ORBuilt 1988 · S/N 24-1670 N5272NMaddie LLC · Hinton, WVBuilt 2009 · S/N 172S10999 N5272PBombach James · Katy, TXBuilt 1958 · S/N 24-311 N5272RRichmond Pilots Corp · Linden, NJBuilt 1974 · S/N 17263486 N5272ZScheda Mark R · Brockport, NYBuilt 1961 · S/N 22-8965 N5273FPsc Leasing LLC · Nokesville, VABuilt 2009 · S/N 18282193 N5273KColumbia Fire & Safety LLC · Wilmington, DEBuilt 2002 · S/N 18281162 N5273LMancuso Dale · Dallas, TXFirst renewal noticeBuilt 1967 · S/N 28-4571 N5273PSouthern View Energy Inc · Lula, GABuilt 1958 · S/N 24-312 N5273RClear Prop Aviation LLC · Sterling, VABuilt 1974 · S/N 17263487 N5273SCarnegie Nursing Home Inc · Carnegie, OKBuilt 1971 · S/N 28-7125209 N5273TFunk Michael W · Windham, NHBuilt 1982 · S/N R18201846 N5273UKatola LLC · Anaheim, CABuilt 2002 · S/N 172S9193 N5273XToledo Jorge A · Miami, FLBuilt 1969 · S/N 175 N52747Unicorn Papa Air LLC · Longwood, FLBuilt 1981 · S/N 17274598 N52749Middle Tennessee State University · Murfreesboro, TNS/N 17274599 N5274HLincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17265392 N5274LRetzer Daniel R · Rockford, ILBuilt 1967 · S/N 28-4573 N5274VH & R Aviation LLC · West Linn, ORBuilt 2009 · S/N 172S11005 N5274XStallings Aircraft Propeller LLC · Wynne, ARBuilt 1969 · S/N 176 N5274ZKotek Steven G · Sparta, WIBuilt 1961 · S/N 22-8967 N52750Wieneke Robert A · Rockwall, TXBuilt 1981 · S/N 17274600 N52753Omark Aviation LLC · Naples, FLBuilt 2002 · S/N 18281164 N52756Fowler Jon E · Cal Nev Ari, NVBuilt 1943 · S/N 245 N52757Brady Aviation Ltd Co · Friendswood, TXBuilt 2002 · S/N 18281165 N5275RNorth Matthew E · Oro Valley, AZBuilt 1978 · S/N R18200641 N5275S75s Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 172S9203 N5275WMustang Sally Aviation LLC · Camden, SCS/N 172S10938 N5275XKirschner David R · Mckeesport, PABuilt 1969 · S/N 177 N5275ZRobertson James W · Cashmere, WABuilt 1961 · S/N 22-8968 N52765Benson Daniel P · Lake Placid, FLBuilt 1977 · S/N 177RG1267 N5276HYagcioglu Deniz S · Eatonton, GABuilt 1949 · S/N 16-80 N5276LHaynie Sidney S · Sedona, AZBuilt 1968 · S/N 28-4575 N5276MBruehl Kenneth · Roseville, CABuilt 1980 · S/N 15284513 N5276PBellers Aviation Inc · Fremont, CABuilt 2009 · S/N 172S11010 N5276WThird Step 2 LLC · Wilmington, DEFirst renewal noticeBuilt 1962 · S/N 28-323 N5276XSanders Curtis E · Morrison, MOBuilt 1969 · S/N 212 N5277HTurner Edward J III · Mokena, ILBuilt 1949 · S/N 16-81 N5277SFers Mitchell A · Stafford Springs, CTBuilt 1970 · S/N 28-26908 N5277WPerkins Nathan Zachery · Bonanza, ORBuilt 1962 · S/N 28-325 N52786Moore Roger · Jonesboro, ARBuilt 1977 · S/N 177RG1270

Back to AD 81-18-04 R2