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.

N2650JNoll Cheryl A · Franklin, NCBuilt 1966 · S/N 15065650 N2650LRholetter Eric W · Westminster, SCBuilt 1967 · S/N 17255850 N2651FMars Aviation LLC · Commerce City, COBuilt 1965 · S/N 18256751 N2651LJohnson Turner C II · England, ARBuilt 1967 · S/N 17255851 N2652FMartindale Lloyd M · Bellingham, WABuilt 1965 · S/N 18256752 N2652LSullivan James M · East Wakefield, NHBuilt 1967 · S/N 17255852 N2652RDevries Francis P · Justin, TXBuilt 1967 · S/N 18258352 N2652VTrapp Terry Lee Trustee · The Dalles, ORBuilt 1974 · S/N 177RG0644 N2653FBagstad Lance · Park Rapids, MNBuilt 1965 · S/N 18256753 N2653QMoses And Associates Inc · Gainesville, FLBuilt 1966 · S/N 18257853 N2654FGregory Daniel · Virginia Beach, VABuilt 1966 · S/N 18256754 N2654LGriner Carrie L · Auburndale, FLBuilt 1967 · S/N 17255854 N2654RFindarle John J · Midway, UTBuilt 1967 · S/N 18258354 N2654VVankirwin Inc · Kinnelon, NJRegistration expired, pending cancellationBuilt 1974 · S/N 177RG0645 N2655QRedmond Angela L · Austin, TXBuilt 1966 · S/N 18257855 N2655RBeck Bartholomew · Dry Ridge, KYBuilt 1967 · S/N 18258355 N2656JSperling Gabriel E · Silverdale, WABuilt 1966 · S/N 15065656 N2656LSzymanski Alexander G · Hernando, MSBuilt 1967 · S/N 17255856 N2656QPankrate Kenneth W · Opheim, MTS/N 18257856 N2656REdex Aviation LLC · Sutter Creek, CAS/N 18258356 N2657FPoolshark Equipment LLC · Memphis, TNBuilt 1965 · S/N 18256757 N2658FClayton Alfred T · Anchorage, AKBuilt 1965 · S/N 18256758 N2658JLife Finds A Way LLC · Sarasota, FLBuilt 1966 · S/N 15065658 N2658RNorthern Science Services LLC · Anchorage, AKBuilt 1967 · S/N 18258358 N26595Levy Alfred E · Richardson, TXBuilt 1971 · S/N 18260616 N2659QMorrison Mark C · Marfa, TXBuilt 1966 · S/N 18257859 N2659RBerrios Antonio · Genoa, ILBuilt 1967 · S/N 18258359 N26601Trowbridge Rodney L · Haysville, KSBuilt 1968 · S/N 18259083 N2660FWheels Up Aviation Inc · Lewes, DES/N 18256760 N2660RPa Bo Ma Inc · Alexandria, LABuilt 1967 · S/N 18258360 N2661ABerry Scott F · Destin, FLBuilt 1968 · S/N 18259102 N2661LHall David B Jr · Midland City, ALBuilt 1967 · S/N 17255861 N2661QAlred Robert I · Barrow, AKBuilt 1966 · S/N 18257861 N2662JHanel Bruce · Placerville, CABuilt 1966 · S/N 15065662 N2662LWaller Leslie P · Cynthiana, KYBuilt 1967 · S/N 17255862 N2662VPeck Kim O · Bolton, MABuilt 1974 · S/N 177RG0647 N2662XTail Aero Corp · Wilmington, DEBuilt 1965 · S/N P206-0162 N2663QBerg Weston L · Stanton, NDBuilt 1966 · S/N 18257863 N2664VKeaveny Kelly J · Annandale, MNBuilt 1974 · S/N 177RG0648 N2665LKay Bennie L · Brigham City, UTBuilt 1967 · S/N 17255865 N2666QCloos Randy J · Osburne, IDBuilt 1966 · S/N 18257866 N2667FVan Hooser Barry S · Pleasanton, CABuilt 1965 · S/N 18256767 N2667RJorgensen Larry C · Randle, WABuilt 1967 · S/N 18258367 N2668FBreaux Robert R · Chino Hills, CABuilt 1965 · S/N 18256768 N2668LEnnis Shannon E · Chesapeake, VABuilt 1967 · S/N 17255868 N2668RCummings Robert S · Bowling Green, KYBuilt 1967 · S/N 18258368 N2669FMichelbrink Hunter J · Gardiner, MTS/N 18256769 N2669LRotormate LLC · Royse City, TXBuilt 1967 · S/N 17255869 N2669QBanks Ron E · Blanchard, OKBuilt 1966 · S/N 18257869 N2669RStrubhar Wesley D · Foster, ORBuilt 1967 · S/N 18258369

Back to AD 72-03-03 R3