Registered aircraft · 17,027

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

N2857RWilson Gary C · Lake Tapps, WABuilt 1967 · S/N 18258457 N2857SCrum Brian B · Warrensburg, MOS/N 15066757 N2858FFlying Fur LLC · Huntsville, ALBuilt 1966 · S/N 18256958 N2858LAgile Systems LLC · Simpsonville, SCS/N 17256058 N2858QKelley Aircraft LLC · Weyers Cave, VABuilt 1971 · S/N 17259858 N2858RWetter Kristian · Fort Myers, FLBuilt 1967 · S/N 18258458 N2859FValley City Flying Club Llp · Valley City, NDBuilt 1966 · S/N 18256959 N2859LWheadon William J · Napa, CABuilt 1967 · S/N 17256059 N2859QSullivan Mark F · Cocoa Beach, FLBuilt 1971 · S/N 17259859 N2859SHout David D · Columbus, OHBuilt 1967 · S/N 15066759 N2860FSullivan Stanley D · South Jordan, UTBuilt 1966 · S/N 18256960 N2860QLawton Metropolitan Area Airport Authority · Lawton, OKBuilt 1971 · S/N 17259860 N2860RStoddard Bruce R · Tucson, AZBuilt 1967 · S/N 18258460 N2861FProair LLC · Dayton, IDBuilt 1966 · S/N 18256961 N2861QBlackmon Robert · San Antonio, TXBuilt 1971 · S/N 17259861 N2861SEagley Ronald A · Anchorage, AKBuilt 1967 · S/N 15066761 N2862FFoxtrot Partners LLC · West Bountiful, UTBuilt 1966 · S/N 18256962 N2862RGuthrie Devin L · Sallisaw, OKBuilt 1967 · S/N 18258462 N2862SGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 15066762 N2862XMathews Nancy M · Englewood, TNS/N 17700262 N2862YDickson Troy S · Placerville, CABuilt 1962 · S/N 18253862 N2863FWright William J · Raeford, NCBuilt 1966 · S/N 18256963 N2863QSalsbery Randall E · Sharpsville, INBuilt 1971 · S/N 17259863 N2863YPiontek Claudia A · Henderson, NVBuilt 1962 · S/N 18253863 N2864FPreszler Sharon J · Mesa, AZBuilt 1966 · S/N 18256964 N2864LTakle Management LLC · Bethany, OKS/N 17256064 N2864QEaglet Flight Operations Lp · Fort Worth, TXBuilt 1971 · S/N 17259864 N2864STop Aircraft Leasing LLC · Wilmington, DEBuilt 1967 · S/N 15066764 N2864XCardinal Airways LLC · St Johns, FLBuilt 1967 · S/N 17700264 N2865FMctaggart Briar · Oroville, CAS/N 18256965 N2865LIfr LLC · Springfield, MOBuilt 1967 · S/N 17256065 N2865QLasalle Charles H · Williamstown, NYBuilt 1971 · S/N 17259865 N2865YSinclair Maurice A · Melrose, IAFirst renewal noticeBuilt 1962 · S/N 18253865 N2866FHowell Thomas F · Red Bluff, CAS/N 18256966 N2866LRegistration Pending · Spring Branch, TXRegistration pendingBuilt 1967 · S/N 17256066 N2866QAircraft & Aviation Professionals LLC · Coldwater, MIBuilt 1971 · S/N 17259866 N2866XFeller Gerald A · Long Beach, CAS/N 17700266 N2867SJarrell Loyd F · Whitesburg, TNBuilt 1967 · S/N 15066767 N2867XThrush Air Lc · Mason City, IABuilt 1967 · S/N 17700267 N2867YCook Kevin M · Hallettsville, TXBuilt 1962 · S/N 18253867 N2868FBrown Isabelle R · Bay Shore, NYBuilt 1966 · S/N 18256968 N2868QRutherford Services Inc · Plains, PABuilt 1971 · S/N 17259868 N2869LHelmstetler John D · Mt Vernon, TXBuilt 1967 · S/N 17256069 N2869QDurnall Daniel J · Sonora, CABuilt 1971 · S/N 17259869 N2869RDiehl Steven L · Martinsburg, PABuilt 1967 · S/N 18258469 N2869YDurand Russell Gene · Luthersville, GABuilt 1962 · S/N 18253869 N2870YDabevv LLC · Salina, UTBuilt 1962 · S/N 18253870 N2871RBlue Ridge Flyers Inc · Leesburg, VABuilt 1967 · S/N 18258471 N2871YJohnson Cynthia Trustee · Sagle, IDS/N 18253871 N2872QTriad Aviation Academy LLC · Greensboro, NCBuilt 1971 · S/N 17259872

Back to AD 72-03-03 R3