Registered aircraft · 81,720

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.

N1481AViseur Michael E · Tulsa, OKBuilt 1952 · S/N 22-389 N1481RMccord Hal E Jr · Pensacola, FLS/N AA1B-0581 N1481VTalbert Barbara E · Wesley Chapel, FLBuilt 1974 · S/N 17263615 N1481XBadgerland Aero Club Inc · Fitchburg, WIBuilt 1975 · S/N 28R-7535289 N14829Ssea Properties LLC · Double Oak, TXBuilt 2007 · S/N 172S10585 N1482CKnutsen Wayne R · Thompson, NDFirst renewal noticeBuilt 1953 · S/N 22-1205 N1482QIngle Benny W · Cherokee, ALBuilt 2014 · S/N 21004 N1482RDavids Samuel W · Woodinville, WABuilt 1975 · S/N AA1B-0582 N1482VGriffin Samuel · Doniphan, MOBuilt 1974 · S/N 17263616 N1483Soper Timothy R · Rathdrum, IDBuilt 1970 · S/N P-483 N1483JMcmillan Gavin · Tarpon Springs, FLBuilt 1977 · S/N 542 N1483L83l Ventures LLC · San Carlos, CABuilt 2007 · S/N 18281960 N1483RLeduc Thomas E · Monterey, CABuilt 1975 · S/N AA1B-0583 N1483UJohnson William Scott · New Market, TNBuilt 1976 · S/N 17267150 N1484BMann Aviation Inc · Long Beach, CABuilt 2007 · S/N 172S10452 N1484JGingles Collie Jr · Mint Hill, NCBuilt 1976 · S/N 484 N1484RLopez Alfred M · Banning, CABuilt 1975 · S/N AA1B-0584 N1484TPolasik Julia Suzanne · Victor, IDBuilt 1972 · S/N 28-7225531 N1484UCrescent City Aviation Club LLC · New Orleans, LABuilt 1976 · S/N 17267151 N1484XAlpha-One Air Service LLC · Concord, NCBuilt 1975 · S/N 28-7505233 N1485RBreeden Wayne M · Memphis, TNBuilt 1975 · S/N AA1B-0585 N1485UClass A Aviators Inc · Parsons, KSBuilt 1976 · S/N 17267152 N1485XBond Bryce W · Chandler, AZBuilt 1975 · S/N 28R-7535290 N1486RRiley Daniel B · Valparaiso, INBuilt 1975 · S/N AA1B-0586 N1486TSpivey Darwyn D · Guntersville, ALBuilt 1972 · S/N 28-7225533 N1486UMoss Motor Company Inc · South Pittsburg, TNBuilt 1976 · S/N 17267153 N1486XMidwest Investment Corp · Griffith, INS/N 28R-7535291 N1487PSingh Harsimran · Las Vegas, NVS/N 23-556 N1487RShepard William E · Peoria, AZS/N AA1B-0587 N1487TFalcon Flying Club LLC · Fayetteville, GABuilt 1972 · S/N 28-7205307 N1487UNew Richard A · Deming, WABuilt 1976 · S/N 17267154 N1487VFirst Flight Corporation · San Diego, CABuilt 1974 · S/N 17263621 N1488Booth Mac E · Independence, ORS/N 303 N1488CChristiansen Aviation LLC · Wilmington, DEBuilt 2022 · S/N 172S12896 N1488UShine Donald J · Waterford, WIBuilt 1976 · S/N 17267155 N1488VPerks Brian G · Otis Orchards, WAS/N 17263622 N1489EWings Over Water Inc · Minneapolis, MNBuilt 1978 · S/N 17271019 N1489LBusiness Mens Flying Club Inc · Naperville, ILBuilt 2007 · S/N 18281901 N1489RSkidmark Services Inc · Debary, FLBuilt 1975 · S/N AA1B-0589 N1489TLion Aviation LLC · Kansas City, MOBuilt 1972 · S/N 32-7200042 N1489UAustin Aeroflight Inc · Austin, MNBuilt 1976 · S/N 17267156 N148AParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020203 N148ACMach 1 Aircraft LLC · Malibu, CABuilt 1993 · S/N 717-93 N148AMEightalphamike LLC · Kissimmee, FLBuilt 2001 · S/N 2148 N148BCWalker Dean M · Fort Collins, COBuilt 2008 · S/N 507-2008 N148BSHodges Mitchell · Powder Springs, GABuilt 2004 · S/N 20-1030 N148CAAfrican Parks Aviation Inc Trustee · Cheyenne, WYBuilt 2005 · S/N 2293 N148CCDream Aero Holdings LLC · Clackamas, ORBuilt 2003 · S/N 9955CC N148DHLeclerc Robert L · Olympia, WABuilt 1994 · S/N 3082 N148DPHenke Kristen C · Bettendorf, IAS/N 11015C

Back to AD 81-18-04 R2