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.

N272TLSanders Flight Training Center · Jasper, ALS/N 17270719 N272TNReed Perry L · Mooresville, NCBuilt 1977 · S/N 17268803 N272VXSpence Lorne J · Saint Cloud, FLBuilt 2019 · S/N 140272 N272WCCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 17272677 N272WYSale Reported · Eden Prairie, MNSale reported, canceledBuilt 2016 · S/N 3272 N272ZMarson Richard W · Eagle River, AKBuilt 1998 · S/N 1050 N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551 N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309 N2730SSesker Matthew Ryan · Ontario, ORBuilt 2026 · S/N 4534 N2730WKegg Larry R · Chesapeake, VABuilt 1966 · S/N 3429 N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265 N2731WUsrey Curtis R · Sullivan, INBuilt 1966 · S/N 1033 N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202 N2732MEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1946 · S/N 12-1225 N2732WReik Martina · Novi, MIBuilt 1966 · S/N 1034 N2733KRegistered aircraftBuilt 2006 · S/N 40517 N2733RPatrick Barb · Farmer City, ILBuilt 1969 · S/N 28R-35275 N2733VOlson Kirk · Dickinson, NDBuilt 1975 · S/N 177RG0676 N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341 N27347Cochran Douglas C · Saranac Lake, NYBuilt 1954 · S/N 18-4032 N2734MGraves Dorel E · Danville, INBuilt 1946 · S/N 12-1226 N2734TMccombs John W · Fairfax, VABuilt 2008 · S/N MC5 N2735MScott Chase · Anchorage, AKBuilt 1946 · S/N 12-1138 N2735PTaylor William W Jr · Hudson Oaks, TXBuilt 1955 · S/N 22-3042 N2735ZSoucy Gary J · Brewer, MEBuilt 1978 · S/N 1232-78 N2736MBrummer Christopher P · Wasilla, AKBuilt 1946 · S/N 12-1137 N2736PBeard Jared · Fallon, NVBuilt 1955 · S/N 22-3043 N2736SVmc Development Inc · Sanger, TXBuilt 2020 · S/N 81921 N2736WMcnamara Jeffrey E Trustee · Riverside, CABuilt 1966 · S/N 1036 N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643 N2737MGautreau Peter F · Chickaloon, AKBuilt 1946 · S/N 12-1141 N2737ZBrown Joseph Earl · Lawrenceburg, INBuilt 1978 · S/N 1233-78 N2738MKerner Frank W · Saint Charles, MOBuilt 1946 · S/N 12-1227 N2738TProtac Aviation LLC · Highland, CAFirst renewal noticeBuilt 1967 · S/N TD-693 N2738WMead James R · Jonesboro, ARFirst renewal noticeBuilt 1966 · S/N 260 N2739CLge Flying Club Inc · Marietta, GABuilt 1978 · S/N R18200223 N2739RPerrong Andrew R · Huntingdon Valley, PABuilt 1969 · S/N 28R-35279 N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344 N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92 N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321 N273BGates Hiram P · Faribault, MNBuilt 1959 · S/N 131 N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112 N273CCRegenald Michaud Aviation LLC · Willows, CABuilt 2001 · S/N 9920CC N273CPCivil Air Patrol · Maxwell Afb, ALBuilt 2012 · S/N 18282354 N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N273EZMoore Monty R · Chancellor, ALBuilt 1981 · S/N 1994 N273JTros Corp · Wilmington, DEBuilt 2017 · S/N 1211 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N273METopel Holdings LLC · Scottsdale, AZBuilt 2000 · S/N T20608217 N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073

Back to AD 81-18-04 R2