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.

N1738FWesley Emerson Holdings LLC · Clifton, TXBuilt 1966 · S/N 17255133 N1739FSessions Jan · Kirbyville, TXBuilt 1966 · S/N 17255134 N173KMLd Enterprises Llp · Roswell, GABuilt 1968 · S/N 17257781 N173MCCiochetti Michael J Jr · Clayton, GABuilt 1968 · S/N 21058960 N173PKTrc-4k Investments LLC · Southlake, TXBuilt 1968 · S/N 17257364 N173VALegner Leasing LLC · Las Vegas, NVBuilt 1971 · S/N 172-60090 N173VFCorlee Douglas K · Palm Coast, FLBuilt 1964 · S/N 17252157 N173VRDauria William · Anna, TXBuilt 1971 · S/N 18260781 N1740FBecton Richard A · San Antonio, TXBuilt 1966 · S/N 17255135 N1742FMarsteller Bruce Paul Jr · Greensburg, PABuilt 1966 · S/N 17255137 N1743FLittle Bird Airways LLC · Hamburg, NYBuilt 1966 · S/N 17255138 N1745FClary David D · Elk Grove Village, ILBuilt 1966 · S/N 17255140 N1747FSmith Jason F · Ronkonkoma, NYBuilt 1966 · S/N 17255142 N1747QAleyda Aviation LLC · Berlin, NJBuilt 1972 · S/N 15073047 N1748FManning Malcolm · Senatobia, MSBuilt 1966 · S/N 17255143 N1748UIliamna Air Taxi Inc · Iliamna, AKBuilt 1976 · S/N 20700348 N1748ZRanz Douglas R · West Bloomfield, MIBuilt 1962 · S/N 205-0047 N1749QScott Andrew F · Beaufort, SCBuilt 1971 · S/N 15073049 N1749UFreshwater Adventures Inc · Dillingham, AKBuilt 1976 · S/N 20700349 N174DVVosters Gary A · Nevada City, CABuilt 1977 · S/N 177RG1268 N174JPGeary Michael Fredrick · Seguin, TXBuilt 1971 · S/N 17259850 N1750FLeggett Lee D · Murfreesboro, NCBuilt 1966 · S/N 17255145 N1750URenfro Michael W · Bethel, AKBuilt 1976 · S/N 20700350 N1754USutton Aircraft Salvage LLC · Palmer, AKBuilt 1976 · S/N 20700354 N1755FSummit Aviation LLC · Belton, SCBuilt 1966 · S/N 17255150 N1756FHeistad Aviation Inc · Houston, TXBuilt 1966 · S/N 17255151 N1756QVerhalen John P Jr · Scottsville, TXBuilt 1971 · S/N 15073056 N1757FAcker David Lynn · Eugene, ORBuilt 1966 · S/N 17255152 N1758UBas Part Sales LLC · Greeley, COBuilt 1976 · S/N 20700358 N1759FOklahoma Flight Academy LLC · Owasso, OKBuilt 1966 · S/N 17255154 N175MTMeyer David A · Broomall, PABuilt 1977 · S/N 17702662 N1760FPark Rapids Avionics Inc · Park Rapids, MNBuilt 1966 · S/N 17255155 N1761FTuttle Trent · Deforest, WIS/N 17255156 N17651Basler Turbo Conversions LLC · Oshkosh, WIS/N R172-0137 N1765FKohler Daniel J · Mapleton, ORS/N 17255160 N1768QHarper John T · Fairfield, OHBuilt 1971 · S/N 15073068 N1769QPmn Enterprises LLC · Fremont, WIBuilt 1971 · S/N 15073069 N1772FTia Aviation LLC · Hot Springs, ARBuilt 1966 · S/N 17255167 N1773BBaney Robert P · Philipsburg, PABuilt 1977 · S/N 17702730 N1773FRegistration Pending · Jasper, ALRegistration pendingBuilt 1966 · S/N 17255168 N1774DDj Brandt LLC · Cedar City, UTS/N 17702028 N1774FBarnstormers Aero Services Inc · Lompoc, CABuilt 1966 · S/N 17255169 N1775QBrooks Timothy J · Oshkosh, WIS/N 15073075 N1778FBlake Brian R · Irvine, CABuilt 1966 · S/N 17255173 N177AWolter Aviation LLC · Charleston, SCBuilt 1975 · S/N 17702284 N177AAKnowles Mark A · Gun Barrel City, TXBuilt 1975 · S/N 177RG0765 N177AMAdler A Michael · Bend, ORBuilt 1976 · S/N 177RG0941 N177APThunderbird Aviation LLC · Littleton, COBuilt 1972 · S/N 177RG0304 N177ARHull Jared Gene · Redondo Beach, CABuilt 1975 · S/N 177RG0782 N177ASManning Bryan E · Northport, ALBuilt 1968 · S/N 17700967

Back to AD 72-03-03 R3