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

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.

N2571HRiker Walter T · Anchorage, AKBuilt 1979 · S/N 18-7909200 N2571MBoston Breeze Aviation LLC · Woburn, MABuilt 1977 · S/N 28-7890258 N2571PStrick Steffen G · Mc Grath, AKBuilt 1955 · S/N 18-4311 N2571QLubbe Klaus · Bethlehem, NHS/N 28-7790408 N2571XRegistration Pending · Augusta, KSRegistration pendingS/N 28-8516037 N2572ASteinhoff Aaron M · Ethel, WABuilt 1952 · S/N 20-938 N2572LBuick Robin B · Redding, CABuilt 1973 · S/N A1500485 N2572MChieftain LLC · Hot Springs, ARS/N 12-941 N2572PRegistration Pending · Roanoke, TXRegistration pendingS/N 18-4312 N2572UVan Scoy Bridget Anne · Shavertown, PAS/N 28-8016038 N2572VJarvis Michael Lynn · Orem, UTBuilt 1974 · S/N 177RG0620 N2572WFlournoy Thomas H · Port Republic, NJBuilt 1965 · S/N 3273 N2572ZRunia Jerry L · Estelline, SDBuilt 1977 · S/N 1000-77 N2573JBusch Bruce K Trustee · Cerritos, CABuilt 1979 · S/N 18-7909132 N2573VOldfield Raymond M Jr · Waupaca, WIBuilt 1974 · S/N 177RG0621 N2573WTrail Air LLC · Springdale, ARBuilt 1965 · S/N 3274 N25743Maile Frank W · Hamilton, NJBuilt 1981 · S/N 38-81A0072 N25746Collins Ronald Rs · Rutledge, TNBuilt 1981 · S/N 38-81A0069 N2574AJones Daryl L · Spokane, WABuilt 1952 · S/N 22-866 N2574GScholl John D · Alexandria, MNBuilt 1967 · S/N 55 N2574XBuckman Warren E III · Pennsburg, PABuilt 1985 · S/N 28-8516047 N2574ZKeegan Ace LLC · Tampa, FLS/N 354-77 N25754Jet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15280767 N25759Rogers Samuel I · Le Roy, KSBuilt 1981 · S/N 38-81A0071 N2575UCavu Aircraft LLC · Salisbury, NCBuilt 1979 · S/N 28-8016042 N2575VStone Tommy R · Jacksonville Beach, FLBuilt 1974 · S/N 177RG0622 N2575ZDavis Mary G · Friendswood, TXBuilt 1977 · S/N 1221-77 N2576AChristopher Steven · Claremore, OKBuilt 1952 · S/N 22-868 N2576FStefany Brian · Euless, TXBuilt 1966 · S/N 420 N2576PWiltz Brothers Inc · Krotz Springs, LAFirst renewal noticeBuilt 1955 · S/N 18-4316 N2576WKepler Anthony · Newberg, ORS/N 935 N2576XOchoa Chase E · Williamsburg, VABuilt 1985 · S/N 32R-8513013 N25772Arnold Jonathan L · Warrensburg, MOBuilt 1977 · S/N 15280774 N25773Solberg Avn Co Inc · Whitehouse Station, NJBuilt 1977 · S/N 15280775 N25775Van Es Mark E · Laredo, TXBuilt 1977 · S/N 15280777 N25779Eads James · Saginaw, TXBuilt 1977 · S/N 15280780 N2577AHelms Michael R Sr · York, SCBuilt 1952 · S/N 22-869 N2577MBales Colton E · Wasilla, AKBuilt 1946 · S/N 12-1051 N2577WSiegel Theodore Matthew · Merritt Island, FLBuilt 1965 · S/N 3275 N25785Iggy Enterprises LLC · Gig Harbor, WABuilt 1977 · S/N 15280783 N2578WCain Mitchell J · Ellisville, MOBuilt 1965 · S/N 3276 N2578ZMcclaskey Leslie Paul · New Albany, OHBuilt 1977 · S/N 348-77 N2579ASharpe Matthew · Olympia, WABuilt 1951 · S/N 22-870 N2579DAnywhere Atp LLC · Mt Juliet, TNBuilt 1978 · S/N 38-79A0361 N2579MBarela Peter A · Wasilla, AKBuilt 1946 · S/N 12-946 N257ABMountain Peak Financial Inc · Palm Desert, CABuilt 1998 · S/N 18280259 N257ACClassic Aviation Inc · Pella, IABuilt 1999 · S/N 1257-99 N257AEBhm Kcak LLC · Akron, OHBuilt 1997 · S/N 18280019 N257ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496071 N257CESimonelli Aviation LLC · Fort Myers, FLBuilt 2024 · S/N 18283257

Back to AD 81-18-04 R2