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.

N33319Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 28-7515328 N3331ABurgess Roy S · Lincoln, NEBuilt 1953 · S/N 22-1607 N3331QEvangelista Ronald · Castle Rock, COBuilt 1977 · S/N 28-7716148 N3331REpik Industrial LLC · Terre Haute, INBuilt 1969 · S/N 28-5661 N3332Degaynor Gregory S · Zeeland, MIBuilt 1971 · S/N 25 N33321Lauher Donna · Wimberley, TXBuilt 1975 · S/N 28-7505133 N33324Central Nebraska Spinal Surgery Center Pc · Kearney, NEBuilt 1975 · S/N 32-7500018 N3332AMarinan Steve · Sanger, TXS/N 22-1606 N3332MFlaugher Jeffrey R · Lake Orion, MIBuilt 1947 · S/N 12-2190 N3332TWilliams Darryl L · Medina, OHS/N 17700632 N3332ZWeisenburger Adam A · Seeley Lake, MTS/N 22-7269 N33338Graham Mark · Fort Smith, ARBuilt 1975 · S/N 28-7525174 N3333BNorlin Lary G · Indianola, IAS/N 22-2148 N3333RBuck Joseph M · Copper Center, AKBuilt 1960 · S/N 18-7565 N3333WRegistered aircraftBuilt 1967 · S/N 28-22874 N33348Air Venture Inc · Hagerstown, MDBuilt 1975 · S/N 28R-7535136 N33349Stroud Jerry · Hope, ARBuilt 1975 · S/N 28R-7535137 N3334EJarmer Ryan F Trustee · San Diego, CABuilt 1978 · S/N 17271509 N3334PM & M Aero LLC · Wilmington, DEBuilt 1978 · S/N 32-7840080 N3334QViking Aerial Photography LLC · Zionsville, INBuilt 1977 · S/N 28-7790449 N3334TBaumann Keith A · Fairfield, ILBuilt 1967 · S/N 17700634 N33350Experimental Acft Assoc Farthest N Chapter 1129 In · Fairbanks, AKBuilt 1946 · S/N 6 N3335ATwotards Aviation LLC · Moses Lake, WABuilt 1953 · S/N 22-1612 N3335BHutsell James M · Miamisburg, OHBuilt 1954 · S/N 22-2150 N3335MRiggin Flight Service Inc · Madison, SDS/N 12-2193 N3335PHill Silas W Trustee · Delta Junction, AKBuilt 1958 · S/N 18-6770 N3335RJones Wesley M Jr · Hollywood, SCBuilt 1969 · S/N 28-5662 N33361Petit Raymond T Trustee · Westerville, OHBuilt 1975 · S/N 28R-7535087 N33363Mcdonald Joseph W · Olympia, WABuilt 1975 · S/N 28-7515312 N33367Smtm Holdings Inc · Wilmington, DEBuilt 1975 · S/N 28-7505136 N3336BNelson Morales · Hendersonville, NCBuilt 1954 · S/N 22-2151 N3336MStevens Matthew Joel · Millersburg, MIBuilt 1947 · S/N 12-2194 N3336WBuck Brothers · Joliet, ILBuilt 1965 · S/N 32-173 N3336ZCedar Mark P · Cherokee, IABuilt 1960 · S/N 22-7276 N33371Galle David R Trustee · Manchester, NHBuilt 1975 · S/N 28-7505137 N33372N33372 LLC · New Bern, NCBuilt 1975 · S/N 28R-7535139 N33376Price Gregory D · Frankfort, ILBuilt 1975 · S/N 28-7515333 N33377Owens Aircraft LLC · Sacramento, CABuilt 1975 · S/N 28-7515334 N33378De Young Robert · Napa, CABuilt 1975 · S/N 28-7505139 N33379Unruh David E · Cadiz, KYBuilt 1975 · S/N 28R-7535141 N3337BJohnson Rader · Cedar City, UTBuilt 1954 · S/N 22-2152 N3337EAltitude Aviation LLC · Lenoir, NCBuilt 1978 · S/N 17271510 N3337MMakarios Air LLC · Loganville, GABuilt 1977 · S/N 32R-7885006 N3337RSpoon Eric T · Cottonwood, CABuilt 1997 · S/N 333 N3338MSyverson Rodney E · Ada, MNBuilt 1947 · S/N 12-2196 N3338RMitchell And Son Aviation LLC · Greenwood, INBuilt 1978 · S/N R18200339 N3338VAero-Tech Services Inc · Lititz, PABuilt 2025 · S/N 172S13307 N3338WQuinto Raymond Richard · Yucaipa, CABuilt 1965 · S/N 32-176 N3338ZKeil Lawrence L · Anchorage, AKBuilt 1960 · S/N 22-7278 N33398Hurdt Reynold A · South Saint Paul, MNBuilt 1975 · S/N 28-7505141

Back to AD 81-18-04 R2