Skip to content

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.

N5509GBottorff James R · Ada, OHBuilt 1969 · S/N 15071009 N5511RLuv2fly Enterprises Inc · Lewes, DEBuilt 1965 · S/N 17253085 N5512RPremier Aircraft Sales LLC · Fort Wayne, INBuilt 1965 · S/N 17253086 N5513REagle Eye Flight Services LLC · Buffalo, MNS/N 17253087 N5514REaa Chapter 1606 Inc · Monticello, UTBuilt 1965 · S/N 17253089 N5516GRegistration Pending · Cedar Hill, TXRegistration pendingBuilt 1969 · S/N 15071016 N5517Hendricks William · Redondo Beach, CABuilt 1965 · S/N 15062568 N5517GCarr Steven F · Wasilla, AKBuilt 1969 · S/N 15071017 N5517RSk Transport LLC · Chicago, ILS/N 17253093 N5518RWings N' Nuts · Bloomfield, NYS/N 17253094 N551CTWaud James L · Hubbard, ORS/N 15065469 N551TSAbc Air Inc · Eveleth, MNBuilt 1968 · S/N 18259381 N5520GRm Aero LLC · Santa Ynez, CABuilt 1969 · S/N 15071020 N5521RRpm Commander Holdings Inc · Deerfield Beach, FLS/N 17253098 N5522GCoffroth James R · Jamestown, TNBuilt 1969 · S/N 15071022 N5523GSamadzai Ahmad W · Mount Vernon, ILBuilt 1969 · S/N 15071023 N5527GFly Around Alaska LLC · Palmer, AKBuilt 1969 · S/N 15071027 N5527RSchultz David M · East Gull Lake, MNBuilt 1965 · S/N 17253106 N5528GRick Aviation Inc · Newport News, VABuilt 1969 · S/N 15071028 N5529GSmoot Jeremy D · Fort Wayne, INS/N 15071029 N5529RCarlson Scott M · Sycamore, ILBuilt 1965 · S/N 17253109 N552KKing Monte L · Kerrville, TXBuilt 1973 · S/N 177RG0367 N552RAGuzman Jose D · Arecibo, PRBuilt 1972 · S/N 15074066 N552RYYoreck Robert J Jr · Clarksville, TNBuilt 1965 · S/N 17253073 N5530RHarris Marilyn L · Hugoton, KSBuilt 1965 · S/N 17253110 N5531RAbraham Philip L · Amery, WIBuilt 1965 · S/N 17253111 N5532RGreco Anthony · Walworth, WIBuilt 1965 · S/N 17253113 N5533GJaeger Robert G · Lake City, FLBuilt 1969 · S/N 15071033 N5535RSmh Aeronautics LLC · Woodville, WIBuilt 1965 · S/N 17253117 N5536RRock Darryl P · Anaheim, CABuilt 1965 · S/N 17253118 N5538RSpringinsguth Wayne R · Bark River, MIBuilt 1965 · S/N 17253121 N553LFLarocque Daniel J · Anchorage, AKBuilt 1964 · S/N 17252121 N553TAIctus Specialized Power Products Inc · Houston, TXS/N 18258199 N5540RAbel Justin Edward · Cincinnati, OHS/N 17253123 N5544RDijon Aviation LLC · Wadsworth, ILBuilt 1965 · S/N 17253129 N5545GTinkham Dennis T · Leavenworth, KSBuilt 1969 · S/N 15071045 N5545RCarlson Michael · Burlington, WYBuilt 1965 · S/N 17253130 N5548RSmietanski Nathan E · Terlton, OKBuilt 1965 · S/N 17253134 N5549GFrantz Donna Pratt · Ocala, FLBuilt 1969 · S/N 15071049 N5550RMetro Technology Centers · Oklahoma City, OKBuilt 1965 · S/N 17253137 N5554RRidge Rickey S · Wortham, TXBuilt 1965 · S/N 17253142 N5556RWbs 1 LLC · Huron, SDBuilt 1965 · S/N 17253145 N5557GSegura Richard J III · Henderson, TXS/N 15071057 N555DDBnc Aviation LLC · Georgetown, TXBuilt 1977 · S/N 177RG1122 N555MLSchramkowski Paul · Brentwood, TNBuilt 1967 · S/N 18257790 N555NJCronin John · Stroudsburg, PABuilt 1968 · S/N 15069885 N555SCBlack Raven LLC · Monroe, LABuilt 1970 · S/N 18260261 N555VPClear Skies Flying Services LLC · Sun Prairie, WIBuilt 1969 · S/N 18259728 N555WBCosta Air Service LLC · Painted Post, NYS/N 17253399 N555WWAdams John G · Marietta, GABuilt 1976 · S/N 177RG1032

Back to AD 72-03-03 R3