Skip to content

Registered aircraft · 17,023

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.

N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431 N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055 N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895 N1402FRegistration Pending · Pomona, CARegistration pendingBuilt 1966 · S/N 17254897 N1403FGoedeker Jr Werner F · Waterville, NYBuilt 1966 · S/N 17254898 N1404CAeroscalper LLC · Goshen, INBuilt 1977 · S/N 17702721 N1406CMcaninch Danny Ray · Pleasant Hill, CABuilt 1977 · S/N 17702722 N1408CHaworth Michael R · Riverside, CABuilt 1977 · S/N 17702723 N1409QDjz Aviation LLC · Kalispell, MTBuilt 1971 · S/N 15072709 N140MAMindy Limited LLC · Muscatine, IABuilt 1970 · S/N 15072399 N140RWTarara Chad L · Webster, MNBuilt 1973 · S/N 15074478 N1410GSierra-Mike LLC · Springdale, ARS/N 15073205 N1410MRapp Steven W · Boulder City, NVBuilt 1971 · S/N 18260580 N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906 N1412QOconnor Melanie Faith · Flagler Beach, FLBuilt 1971 · S/N 15072712 N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908 N1413QWolf John C · Bethel, PABuilt 1971 · S/N 15072713 N1414FPalmer Matthew B · Riverside, CABuilt 1966 · S/N 17254909 N1414QForsman Robert J · Jber, AKBuilt 1971 · S/N 15072714 N1417QSteinke William A · Mount Juliet, TNBuilt 1971 · S/N 15072717 N1419CVetrone Troy · Wisconsin Rapids, WIBuilt 1977 · S/N 17702724 N141JGCardinal 1jg LLC · Bakersfield, CABuilt 1968 · S/N 17700930 N1420FGaither John A · Rumsey, KYBuilt 1966 · S/N 17254915 N1420QSweet Sanford L · Tawas City, MIS/N 15072720 N1423FSayers Carl D · Vidalia, LABuilt 1966 · S/N 17254918 N1424FDutton Timothy F · Vassalboro, MEBuilt 1966 · S/N 17254919 N1424QPadilla Cresencio I · Big Spring, TXBuilt 1971 · S/N 15072724 N1425FHuarte Shawn D · Sammamish, WAS/N 17254920 N1426FMiller John T III · Greeneville, TNBuilt 1966 · S/N 17254921 N1426QJr Imaging Logistics Inc · Pasco, WABuilt 1971 · S/N 15072726 N1427FHampton Stephen L · Culbertson, MTBuilt 1966 · S/N 17254922 N1428FPuttre John W · Sullivan, WIBuilt 1966 · S/N 17254923 N1429FLathrop Mark · Franklin, NCBuilt 1966 · S/N 17254924 N1429QReeves Richard E · Lincoln, NEBuilt 1971 · S/N 15072729 N142EZAttacoa Air LLC · Juneau, AKBuilt 1972 · S/N 15074086 N142RSReinmuth Michael W · Lopez Island, WAS/N 18253832 N142SBSopha Kim A · Poynette, WIBuilt 1969 · S/N 15070717 N1430QGearhart Robert H · Three Rivers, MIBuilt 1971 · S/N 15072730 N1431FAir Pirates Flying Club LLC · Virginia Beach, VABuilt 1966 · S/N 17254926 N1432FMcabee Patrick A · Tampa, FLS/N 17254927 N1432KCovenant Physician Services Ltd · London, OHBuilt 1975 · S/N 177RG0665 N1433FAnderson Jesse Thomas · Phoenix, AZBuilt 1966 · S/N 17254928 N1434FWinkelman Donald L · Anchorage, AKBuilt 1966 · S/N 17254929 N1435QWeaver G Thomas · Fairbanks, AKBuilt 1971 · S/N 15072735 N1437FKelly William W · Springfield, ORBuilt 1966 · S/N 17254932 N1437QPeyton Jerry L · Sebeka, MNBuilt 1971 · S/N 15072737 N1438CTony And Oats Great Adventure LLC · Danville, INBuilt 1977 · S/N 17702727 N1438FBermudez Santana Tacito O · Conyers, GAS/N 17254933 N1439FHallock Lloyd E · Columbia, MOBuilt 1966 · S/N 17254934 N143AKLipinski Glen E · Chandler, AZS/N 15074168

Back to AD 72-03-03 R3