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.

N3806FSkytours Aerial LLC · Jackson, MIBuilt 1977 · S/N 0774 N3806MAbbott Cedric M · Buckfield, MEBuilt 1947 · S/N 12-2563 N3806TFacklair LLC · Granville, OHBuilt 1967 · S/N 28R-30120 N3806ZNamtvedt Erik · Wasilla, AKS/N 18-7539 N3807FDeno Gerald G · Battle Creek, MIBuilt 1977 · S/N 0775 N3807JJohnson Gunnar W · Wasilla, AKBuilt 2012 · S/N 00100 N3807KFaucette Micro Systems Inc · Fallon, NVS/N WA-200 N3807MRenner Robert C · Erie, PABuilt 1947 · S/N 12-2729 N3807PLuebber Jan D · Malaga, WAS/N 22-3496 N3807WFeller Gerald A · Long Beach, CAS/N 32-736 N38086Autumn Crocus LLC · Cincinnati, OHS/N WA-210 N3808ASturges George S Jr · Bakersfield, CAS/N 22-1868 N3808FChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 0776 N3808MWings Of Clearfield Inc · Centre Hall, PABuilt 1978 · S/N 28-7816377 N3808RCatalano Joan E · Sequim, WABuilt 1970 · S/N 28-5834 N3808WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-737 N3809MWood Robert A V · Anchorage, AKBuilt 1947 · S/N 12-2731 N3809TMiller Jo Ann · Atlanta, GABuilt 1967 · S/N 28R-30124 N3809UMartus Michael · Russellville, OHBuilt 1980 · S/N WA-211 N3809WFair Skies Aviation LLC · Cincinnati, OHBuilt 1966 · S/N 32-739 N3809YShaffer Kent R · Sour Lake, TXFirst renewal noticeBuilt 1980 · S/N WA-212 N3809ZHelm Charles M · Darlington, WIBuilt 1980 · S/N WA-213 N380AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496618 N380BPMoe Michael J · Detroit Lakes, MNBuilt 1996 · S/N 1 N380BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010084 N380CCHolmstrom Eric C · Las Vegas, NVBuilt 2001 · S/N 9934CC N380CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282459 N380DMWiles Shawn Lynn · Lakeland, FLBuilt 2008 · S/N 40559 N380ESZak William Roy Jr · Kissimmee, FLBuilt 1997 · S/N 18280053 N380GPaxton Ronald R · Colorado Springs, COBuilt 1972 · S/N 380 N380KCitabria Corporation · Wilmington, DEBuilt 2011 · S/N 543-2011 N380KPPeterson Timothy J · Watertown, SDBuilt 1947 · S/N 11-1586 N380LCLorusso Jason J · Hadley, MABuilt 2022 · S/N 41905 N380MA75 East Air LLC · Valparaiso, INBuilt 1999 · S/N 18280561 N380MCVeturis David L · Lake Forest, CAS/N 128-1054 N380MEVpc Air Inc · Cartersville, GABuilt 2000 · S/N 172S8559 N380MFRegistered aircraftBuilt 2003 · S/N 0038 N380RADarnell Charles Bert · Glen Allan, MSBuilt 2005 · S/N 1380-2005 N380RBShea Michael P · Nashua, NHBuilt 1987 · S/N 380 N380UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2005 · S/N 4496211 N380WGGuhl Wolfgang · Marietta, GABuilt 2010 · S/N 91618 N380XBourgeois Olivier F · North Andover, MABuilt 1975 · S/N 177RG0751 N381Deal Mark A · Spartanburg, SCBuilt 1978 · S/N 3072 N3810FTomco Stores Ltd · Ruidoso, NMBuilt 1977 · S/N 0778 N3810MSurgical Innovations Inc · Suwanee, GABuilt 1978 · S/N 28-7816378 N3810TN3810t LLC · Kalispell, MTS/N 28R-30125 N3811KHendrickson Raymond G · Severn, MDBuilt 1967 · S/N 28-23737 N3811MBanks Jerry A · Collierville, TNBuilt 1969 · S/N 28R-35200 N3811TDeleon Muniz Mario Antonio · Riverside, CABuilt 1967 · S/N 28R-30126 N3811WMartin Gerard A · Boston, KYBuilt 1966 · S/N 32-741

Back to AD 81-18-04 R2