Registered aircraft · 250

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-16-02-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-16-02-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-16-02-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-16-02-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-16-02-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-16-02-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.

N6134Brown Garry M · Riverside, CABuilt 1952 · S/N CA-274 N62936Prop And Jet Air Museum · Romoland, CAS/N CA38 N62CJMcclain Dean L · Torrington, WYBuilt 1962 · S/N BA-633 N6495DPreserve Aviation History LLC · Cape Coral, FLBuilt 1960 · S/N AF-449 N649BSpirit Engineering Inc · Grand Junction, COBuilt 1948 · S/N A-454 N651BSjc IV LLC · Lawrence, KSBuilt 1949 · S/N A-478 N6623Szostak Edward M · San Diego, CABuilt 1946 · S/N A-295 N663TBMcmillan Peter H · San Francisco, CABuilt 1964 · S/N BA-663 N6670Beinhauer Richard G · Naperville, ILBuilt 1952 · S/N CA-98 N6675Tarrington Thomas A · Mt Clemens, MIRegistration revokedBuilt 1952 · S/N CA-256 N6BAMcmanigle Jeff · Osakis, MNBuilt 1946 · S/N A-406 N700TNInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N BA-718 N7032Gohman Charles S · Salinas, CABuilt 1943 · S/N 67232 N70GAAmerican Airpower Heritage Flying Museum Inc · Dallas, TXBuilt 1966 · S/N A-177 N70WWIsland City Seaplanes Inc · Cordova, AKS/N A-38 N712JSBeechcraft Heritage Museum · Tullahoma, TNBuilt 1959 · S/N BA-453 N7185Continental Title Trust LLC · Wichita, KSS/N CA-104 N71GJSkydive Greene County Inc · Xenia, OHBuilt 1954 · S/N AF-629 N727AVSkyline Eighteen LLC · Setauket, NYBuilt 1960 · S/N BA-560 N729MWpp Nautical LLC · Waller, TXBuilt 1960 · S/N BA-517 N73548Smith Salvage And Restoration Services LLC · New Berlin, TXS/N A-548 N737SWAztec Worldwide Airlines Inc · Wilmington, DEBuilt 1959 · S/N BA-402 N74GJSkydive Greene County · Xenia, OHBuilt 1961 · S/N BA-559 N75BBWarbirds 1 LLC · Chattanooga, TNBuilt 1952 · S/N 51-11638 N75GJSkydive Greene Co Inc · Xenia, OHBuilt 1964 · S/N BA-711 N75JCWilliams Austin · Valdosta, GABuilt 1946 · S/N A-256 N75QVr Jet LLC · Goshen, INBuilt 1951 · S/N AF-423 N7694CMiddle Keys Experimental Aircraft Association Inc · Marathon Shores, FLBuilt 1951 · S/N AF-24 N76ADynamic Avlease Inc · Bridgewater, VABuilt 1957 · S/N BA-262 N777XJFields David B · Midland, TXS/N BA-726 N7805CAtropos Group Inc · Arlington, VABuilt 1954 · S/N AF-640 N7826LTri-State Warbird Museum · Batavia, OHBuilt 1951 · S/N AF-86 N7916ABeechcraft Heritage Museum Inc · Tullahoma, TNS/N AF-824 N7998KHoughton Justin K · North Ferrisburg, VTBuilt 1965 · S/N BA-699 N79AGAmerican Airpower Heritage Fly Musm · Dallas, TXBuilt 1952 · S/N A-806 N7BSRunyon Aviation LLC · Fort Worth, TXBuilt 1954 · S/N BA-18 N7MBGlenn Michael H · Midland, TXBuilt 1959 · S/N BA-448 N80036Beechcraft Heritage Museum · Tullahoma, TNBuilt 1946 · S/N A-187 N80152Culpepper Matt D · Las Vegas, NVBuilt 1946 · S/N A-112 N80197Pgt Nuclear LLC · College Station, TXS/N A-171 N80240Beech 18 Holdings LLC · Sheridan, WYBuilt 1951 · S/N AF-75 N80323Bachus & Son Inc · Wichita, KSBuilt 1957 · S/N AF-1 N80373Virgil J Tatman · Casper, WYS/N A-273 N80388Valiair Lc Trustee · Casper, WYBuilt 1946 · S/N A-288 N8389HPoplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1958 · S/N 51-11836A N843TBFarwell Jesse R · Albion, NYS/N A217 N8476HMccole Joanne · Brookline, NHS/N BA-749 N8495AQualitair LLC Trustee · MichelstadtS/N BA-668 N8504Clay-Klein LLC · Indianapolis, INBuilt 1952 · S/N AF-682 N8627AMckinney Steve R · Hamersville, OHBuilt 1957 · S/N BA-283

Back to AD 72-16-02 R3