Registered aircraft · 47,133

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N433CAJaxcor LLC · Temecula, CABuilt 2023 · S/N 9503 N433CFRotormate LLC · Royse City, TXS/N 0710 N433CPPaul Family Properties - Texas LLC · Wasco, CABuilt 2008 · S/N 3070 N433DReyenga Steven G · Shreveport, LABuilt 1966 · S/N D-8094 N433DNGary Boyce Aircraft Sales LLC · Shelbyville, TNBuilt 1990 · S/N CE-1475 N433KHuffine Kenneth A · Caswell Beach, NCBuilt 1968 · S/N TE-564 N433LCarolina Warbirds LLC · Patuxent River, MDBuilt 1961 · S/N D-6850 N433MJCousin Elisabeth Trustee · Pompano Beach, FLBuilt 2004 · S/N 1469 N433MLMca Inflight LLC · Summerdale, ALBuilt 2019 · S/N 1936 N433SBesedin Thomas E · Islandia, NYBuilt 1965 · S/N D-8006 N433SBRico Kermot Aviation LLC · San Clemente, CABuilt 1969 · S/N 18259876 N433TMChristensen Michael S · Mesa, AZBuilt 2002 · S/N 0144 N4340GHaynie Airline LLC · Boca Raton, FLBuilt 1984 · S/N 28R-8431015 N4340WHanger Aviation Inc · Charleston, SCBuilt 1974 · S/N D-9577 N43412Registered aircraftBuilt 1984 · S/N 46-8408034 N4341NGg And Sg Properties LLC · Seminole, FLBuilt 1984 · S/N 46-8408031 N4342AR&B Air LLC · Clayton, MOBuilt 1970 · S/N D-9133 N4343PEnvironmental Enterprises Inc · Cincinnati, OHBuilt 1984 · S/N 34-8433034 N4344RCash Doug · Newton, IABuilt 1972 · S/N TE-859 N4348MDavison Noel C · Covington, KYBuilt 1984 · S/N 28R-8431020 N4348YFlamingo Express LLC · Jacksonville, FLBuilt 1984 · S/N 34-8433040 N4349AJensen Jay Delayne · Cabot, ARBuilt 1984 · S/N 28R-8431013 N434BRRoberts Aviation LLC · Myrtle Beach, SCBuilt 2026 · S/N 11320 N434CCLambo Air LLC · Springtown, TXBuilt 1982 · S/N EA-321 N434CDFlycarolina LLC · Concord, NCBuilt 2005 · S/N 1514 N434DKOshaughnessy Terrence · Boulder City, NVS/N LIV 419 N434JGGordon Adam Leo · Oakdale, LABuilt 1979 · S/N 18503785 N434JHCloud 9 Wings LLC · Webberville, MIS/N 53-4148 N434JRMentor Holdings LLC · Columbia, MDS/N 140839 N434KBConnecting Aviators LLC · Katy, TXBuilt 2026 · S/N 11300 N434LQualitair LLC Trustee · MichelstadtS/N D-8694 N434MGAviation Trust Company LLC · Oklahoma City, OKBuilt 2011 · S/N E-3953 N434MMMlc Aviation LLC · Inver Grove, MNBuilt 2007 · S/N 2643 N434RSWestfall Brent J · Three Lakes, WIBuilt 1968 · S/N TE-582 N434SRMiller Richard Francis · Waxhaw, NCBuilt 2007 · S/N 2557 N434TBFlightworks LLC · Crozet, VAS/N 0290 N434TX22t-11239 LLC · Austin, TXBuilt 2026 · S/N 11239 N4354RNoel Laura · Erie, COBuilt 1976 · S/N 18502937 N4355NPiper Aircraft Inc · Vero Beach, FLBuilt 1984 · S/N 28R-8431023 N4356RTailwind Innovations Inc · Overland Park, KSS/N 18502939 N4358KRyder William Alden III · Moon Township, PABuilt 1948 · S/N NAV-4-1358 N4358MKimt LLC · Iron Mountain, MIBuilt 1984 · S/N 46-8408048 N4358QPeters Nicholas J · Eagle River, AKBuilt 1973 · S/N 18502237 N4358XSga Alaska Leasing LLC · Anchorage, AKBuilt 1975 · S/N 34-7670027 N435CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 0836 N435CPNext Century Aviation LLC · Boca Raton, FLBuilt 2008 · S/N 3264 N435JAJorgensen Aviation Inc · Richfield, UTBuilt 2016 · S/N 1419 N435JMBonanza A36 LLC · Nashville, TNBuilt 1975 · S/N E-762 N435MGonzalez Frank · Sun Valley, CABuilt 1992 · S/N E-2726 N435MCSmoketown Flight Center LLC · Smoketown, PABuilt 1967 · S/N TE-435

Back to AD 2000-23-21