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.

N4329FStrathman Aerial Spraying LLC · Axtell, KSBuilt 1980 · S/N 36-8060009 N4329MByrne Matthew A · West Allis, WIBuilt 1983 · S/N 28-8490021 N4329PDunn Danvil L · East Meadow, NYBuilt 1983 · S/N 28-8490022 N4329QElfers Brian K · Colfax, WAFirst renewal noticeBuilt 1971 · S/N 17260229 N4329XS&S Aircraft Inc · Bennington, VTBuilt 1975 · S/N 28R-7635011 N4329YDetert Bradley · Valparaiso, INBuilt 1966 · S/N 27-619 N4329ZWalters Leif C · Wasilla, AKBuilt 1968 · S/N 18-8644 N432AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2004 · S/N 172S9715 N432AEArnold Neil · Caro, MIBuilt 1968 · S/N 690019 N432APSky Bear LLC · Marfa, TXBuilt 2024 · S/N 3432 N432BQBrowning Aviation LLC · Deputy, INS/N Q-002 N432CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13245 N432CMFuller Carl C · Fairplay, MDS/N 25105 N432DGBiddle Dave S · Cave Creek, AZBuilt 2001 · S/N 60210 N432DRJazz Air LLC · Melbourne, FLBuilt 1997 · S/N 3246084 N432DSButler Jeffrey W · Santaquin, UTBuilt 2001 · S/N 40032 N432ERUnicorn Wings LLC · Cary, ILBuilt 1998 · S/N 17280652 N432HPFuehrer Wyatt R · Coatesville, INBuilt 1977 · S/N 28-7790547 N432KCKjomo Aviation LLC · Ocean Springs, MSBuilt 2004 · S/N 3246225 N432LELeading Edge Flight Academy LLC · Bend, ORBuilt 2006 · S/N 4032 N432MBJenks Jesse Basil · Cambria, CABuilt 2011 · S/N 001 N432MEEdwards Michael S · Sacramento, CAS/N 18-7609131 N432MJ43rd Aviation Flying Club Inc · Wethersfield, CTBuilt 1983 · S/N 241413 N432NCHerbert Jason Brian · Saginaw, MIBuilt 1978 · S/N 32R-7885090 N432PWSimple Aviation LLC · Suwanee, GABuilt 2014 · S/N 92051 N432RVShort Thaddeaus Allen · Conroe, TXBuilt 2006 · S/N 60269 N432TTBeam John A III · Old Hickory, TNBuilt 2000 · S/N 21089 N433Precision Air Inc · Manning, SCBuilt 1979 · S/N AA5B1189 N4330DHildebrand David S · Albuquerque, NMBuilt 1983 · S/N 28-8490026 N4330EDooley Jon S · Greensburg, INS/N 38-78A0555 N4330MCarson Brian P · Battle Creek, MIBuilt 1947 · S/N 12-3269 N4330QSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 1971 · S/N 17260230 N4330RBellinger Joshua · Monterey, CABuilt 1983 · S/N 28-8411005 N4330TBc 180 LLC · Chouteau, OKBuilt 1971 · S/N 28-7205142 N4330ZOcean Aerial Ads Inc · Ocean City, MDBuilt 1968 · S/N 18-8650 N43311Myers James · Coolidge, AZBuilt 1974 · S/N 28-7425355 N43314Gardners Guns & Mfg LLC · Elk City, OKBuilt 1984 · S/N 28-8490029 N43316Double M Aviation LLC · Lakeland, FLBuilt 1974 · S/N 28-7415468 N4331BParker Charles B · Fort Myers, FLBuilt 1983 · S/N 32-8406003 N4331CLance Air Inc · Taylorsville, KYBuilt 1983 · S/N 32R-8413004 N4331DAlvarado John · Brownsville, TXBuilt 1983 · S/N 28-8411004 N4331MNieves Osvaldo Colon · San Juan, PRS/N 28-8416028 N4331PWilson Cecil · Lithonia, GABuilt 1983 · S/N 28-8416029 N4331QLewis Brandon · Columbiaville, MIBuilt 1971 · S/N 17260231 N4331RConsolidated Aviation Services LLC · Seymour, TNBuilt 1974 · S/N 17263084 N4331XS E D Air LLC · Kimball, SDBuilt 1975 · S/N 28-7625013 N4331YOdonnell Daniel V · Dover, DEBuilt 1968 · S/N 25-4821 N43321Alexander Terry · Stamps, ARFirst renewal noticeBuilt 1974 · S/N 28-7425357 N43325Air Ventures Flying School LLC · Smithfield, RIBuilt 1974 · S/N 28-7425358 N43326Draco Flight School DBA · Chino, CABuilt 1974 · S/N 28-7415471

Back to AD 81-18-04 R2