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.

N33836Patton Daniel E · Thornton, PABuilt 1975 · S/N 28-7505186 N3383ABishop John Patrick · Annapolis, MDBuilt 1953 · S/N 22-1646 N3383BEvans Johnny D II · Billings, MTBuilt 1954 · S/N 22-2182 N3383TBerkstresser John A · Ellijay, GABuilt 1967 · S/N 17700683 N3383WFour Dudes Flying LLC · Cabot, ARBuilt 1965 · S/N 32-239 N3383XHiger Matthew Ward · Las Vegas, NVBuilt 1966 · S/N 1096 N3383ZMcghee Johnny A · Louisburg, NCBuilt 1960 · S/N 18-7267 N33847Registered aircraftBuilt 1975 · S/N 28-7525249 N33848Crymes Robert S · Woodbridge, VABuilt 1975 · S/N 28-7505187 N33849Sanzaro Aero LLC · Bunnell, FLBuilt 1975 · S/N 28R-7535206 N3384XWendt Wesley A · Leavenworth, KSBuilt 1966 · S/N 1097 N3384ZJones Robert D Jr · Chugiak, AKBuilt 1960 · S/N 18-7268 N33850Jbm Ventures Inc · Apollo Beach, FLBuilt 1975 · S/N 28-7510068 N3385BSlipshod Aviation LLC · Hurricane, UTBuilt 1954 · S/N 22-2184 N3385XKelly Paul M · Granite Bay, CABuilt 1966 · S/N 3383 N33863N318bm LLC · Monroe, LABuilt 1975 · S/N 28R-7535208 N33864Hirsch Bernard David · Carmel, INS/N 32-7500033 N338672 F LLC · Valentine, NEBuilt 1975 · S/N 28R-7535209 N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526 N3386WTranswestern Air Service Inc · Golden, COBuilt 1965 · S/N 32-244 N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687 N3387ZBlake Clark D · Belle Fourche, SDBuilt 1960 · S/N 18-7271 N3388BMccracken Scott O · Maysville, OKBuilt 1954 · S/N 22-2187 N3388MPatton Derek L · Fort Wainwright, AKBuilt 1947 · S/N 12-2056 N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351 N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688 N3388WTexas Wings LLC · San Antonio, TXBuilt 1965 · S/N 32-246 N3388XRoth Joe D · Livingston, TXBuilt 1966 · S/N 1099 N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528 N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352 N3389TSmith Barry Stephen · Huntsville, ALBuilt 1974 · S/N 224 N3389WUniversity Of Alaska Anchorage · Anchorage, AKBuilt 1965 · S/N 32-247 N3389ZTorgerson'S LLC · Ethridge, MTBuilt 1960 · S/N 18-7274 N338BFBravofox LLC · Indianapolis, INBuilt 2025 · S/N BCV.21002 N338BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 2881263 N338BSMcnabb William B · Kingsport, TNBuilt 2002 · S/N 80310 N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465 N338CTAv8 Flight Assets LLC · Eden Prairie, MNBuilt 2023 · S/N 1338 N338ELawffer Noel J · Amboy, WABuilt 2020 · S/N 001 N338EEHansen Carl A · Bowie, MDBuilt 1965 · S/N 588 N338GSSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13326 N338MAHayes & Associates Inc · Teays, WVBuilt 2003 · S/N 40.298 N338MEBoulant Michael Lee Charles · Las Vegas, NVBuilt 2000 · S/N 18280730 N338MKNorth Star Aviation · Mankato, MNBuilt 2019 · S/N 2881096 N338NEldor Industries Inc · Toledo, OHBuilt 1982 · S/N 60-8365008 N338NAMeister Scott R · Skillman, NJBuilt 1978 · S/N 60-0487-158 N338PMMarso Peter G · Decorah, IABuilt 2019 · S/N KA15081311 N338QJones Thomas P · Quartz Hill, CABuilt 1971 · S/N 70 N338RATeufel Kirsi Katariina · Ontario, ORBuilt 1978 · S/N 13116 N338RVSalvini John M · San Luis Obispo, CABuilt 2004 · S/N 80696

Back to AD 81-18-04 R2