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.

N2856DDunn Leslie K · Scottsdale, AZBuilt 2010 · S/N 0022368 N2856HFlight School 101 LLC · Winter Haven, FLS/N 28-7916482 N2856PHester Alan A · Battle Ground, WABuilt 1955 · S/N 22-3156 N2856TGreene Thomas M · Chapel Hill, NCS/N 28-7916483 N2856XHorn Paul M · Vacaville, CAS/N 17700256 N2856ZCooksey Donald R · Newcastle, WYBuilt 1959 · S/N 22-6853 N28572Peck Jeff · Denton, TXS/N AA5B0688 N28573Bearpaw Aviation LLC · Brookfield, WIBuilt 1977 · S/N AA5B0689 N28575Maxwell Jay Nate · Cookeville, TNBuilt 1977 · S/N AA5B0690 N2857MCoastal Air Services LLC · Hampton, SCBuilt 1977 · S/N 32-7840057 N2857PSale Reported · Greeley, COSale reportedBuilt 1979 · S/N 28-7990501 N2857QM3 Aviation Florida LLC · Fort Pierce, FLBuilt 1971 · S/N 17259857 N2857XWalton Wade · Downingtown, PABuilt 1979 · S/N 28R-7918179 N28583Mcgee Michael R · Mamou, LABuilt 1977 · S/N AA5B0691 N28584Cereal City Flying Club LLC · Battle Creek, MIBuilt 1977 · S/N AA5B0692 N2858HSundt Daniel N Jr Trustee · Bryn Mawr, PABuilt 1979 · S/N 32-7940162 N2858PSiegfried Richard W · Downers Grove, ILBuilt 1955 · S/N 22-3159 N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858 N2858ZRoberts Darren T · Vail, AZBuilt 1959 · S/N 22-6855 N28591Toher Wayne R · Danbury, CTBuilt 1977 · S/N AA5B0696 N28593Mcmillan David S · Rangeley, MEBuilt 1978 · S/N AA5B0697 N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859 N2859TGouda Rafik M · Rancho Cucamonga, CABuilt 1972 · S/N 28-7225254 N285AAGoldrock Aviation LLC · Princeton, NJBuilt 1974 · S/N 28R-7435156 N285BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842420 N285BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881664 N285CSDrury'S Journey LLC · Los Altos, CABuilt 2020 · S/N 18283095 N285CVBarr Air Patrol LLC · Mesquite, TXBuilt 1997 · S/N 18280059 N285DM4 Play Aviation LLC · Port Orange, FLBuilt 1997 · S/N 1236-97 N285DSMonmouth Area Flying Club Inc · Lakewood, NJBuilt 2003 · S/N 40.285 N285EASouth Carolina Forestry Commission · Columbia, SCBuilt 1999 · S/N 18280524 N285EJCounce Mitchell K · Goodyear, AZBuilt 2011 · S/N 91845 N285HCStiller Mark R · Anchorage, AKBuilt 1960 · S/N 18-7464 N285JACarroll Aviation Inc · Carroll, IABuilt 1997 · S/N 2843105 N285JSFlytruckeetahoe Inc · Truckee, CABuilt 1976 · S/N 17268035 N285KYCharlie Lima Tango Enterprises LLC · San Francisco, CABuilt 2021 · S/N 3373 N285MGGeorgia Aviation Authority · Eastman, GAFirst renewal noticeBuilt 2017 · S/N 2844167 N285MJEagle Aviation LLC · Anchorage, AKBuilt 2012 · S/N MRB-001 N285MKPlane Nonsense Inc · Middletown, DEBuilt 2004 · S/N 2842201 N285PDennin Michael E · Minden, LABuilt 1968 · S/N 28-24804 N285PEBravo Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10888 N285QAdams Aircraft LLC · Wilmington, DES/N 297 N285TCooper John H III · Wasilla, AKBuilt 1953 · S/N 18-2399 N285TARegistration Pending · Augusta, KSRegistration pendingBuilt 1977 · S/N 28-7716239 N285THAtp Aircraft 2 LLC · Wilmington, DEBuilt 2018 · S/N 172S12130 N285TRRhoads Timothy C · Logan, NMS/N 2120 N285VNElizabeth City State University · Elizabeth City, NCBuilt 2019 · S/N 172S12414 N285WY46u LLC · Anaconda, MTBuilt 2017 · S/N 3285 N285ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881639 N28604Quest Technical Sales & Marketing Inc · Westlake Village, CABuilt 1978 · S/N AA5B0701

Back to AD 81-18-04 R2