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.

N40JTTct Aerial LLC · Waukesha, WIBuilt 1952 · S/N CA-128 N411JAukes Brian E · Huxley, IABuilt 1953 · S/N A-967 N41289Nizex Inc · Jackson, GAS/N A-475 N412KKourtis Vintage Aviation LLC · Owasso, OKBuilt 1946 · S/N A-263 N418GBClaire Aviation Inc · Wilmington, DEBuilt 1944 · S/N 76755 N4207American Airpower Hrtg Flg Museum · Dallas, TXBuilt 1943 · S/N 67124 N42114Spiller Gary W · Lafayette, ORS/N 39815 N42CStage One Associates LLC · Oxford, CTS/N A-468 N42DMajerle Michael A · Big Lake, AKS/N BA-117 N4356GTop Hand Inc · Laurel, MTBuilt 1951 · S/N CA56 N43927Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1945 · S/N A-26 N44607Shepard Group LLC · Mena, ARBuilt 1945 · S/N A-15 N44638Vintage Aircraft Inc · Stockton, CAS/N A-45 N4477Parish John Sr · Tullahoma, TNBuilt 1952 · S/N A-935 N447DMMorlock Inc · Crossville, TNS/N AF269 N450TAKestrel Inc · West Des Moines, IABuilt 1959 · S/N BA-482 N45CFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1959 · S/N BA466 N45GCAshworth Corp Inc · Geneseo, NYBuilt 1954 · S/N AF-469 N45SKPlane Fun Inc Tr Trustee · Snellville, GABuilt 1952 · S/N AF-645 N471CMMartin-Remesz Michele · Boca Raton, FLBuilt 1955 · S/N BA-76 N476PASilver Wings Flying Company LLC · Olympia, WAS/N CA-265 N47GLaunder Brian L · Tulsa, OKBuilt 1957 · S/N BA-289 N480PPlane Fun Inc Tr Trustee · Snellville, GAS/N 52-10885 N48MGarrison William E · Nickerson, KSBuilt 1996 · S/N BA-155 N491DMRst Aviation LLC · Vero Beach, FLBuilt 1952 · S/N 52-10643 N496DMGoff Richard A · Plevna, MTS/N AF-298 N4DHGlenn L Martin Maryland Aviation Museum · Baltimore, MDBuilt 1946 · S/N A-260 N50225Mayes John · Carson City, NVS/N BA-619 N502DDWaller County Aviation Museum · Brookshire, TXBuilt 1960 · S/N BA-542 N50WAClements Bruce · The Villages, FLBuilt 1962 · S/N BA-616 N5180VSunzeri Jeffery J · Hollister, CABuilt 1959 · S/N 51-11689A N52DNAir Apparent Aviation LLC · Plant City, FLBuilt 1952 · S/N A-846 N54CXIsland City Seaplanes Inc · Cordova, AKBuilt 1956 · S/N BA-175 N54KLumley William B · Delray Beach, FLBuilt 1957 · S/N BA-235 N555WSDeer Creek Dusters Inc · Rolling Fork, MSBuilt 1956 · S/N BA-168 N5609DReed Steven W · San Marcos, TXBuilt 1957 · S/N BA-315 N5644DPlane Crazy Aviation LLC · Hickory, NCBuilt 1958 · S/N BA-360 N5668DLetzelter C J · Littleton, COBuilt 1959 · S/N BA-416 N5804CGeorge Andrew N · Corvallis, ORBuilt 1951 · S/N A579 N5867Yarbrough Michele E · Vacaville, CABuilt 1957 · S/N BA-333 N5959FMid Atlantic Air Museum · Reading, PABuilt 1965 · S/N BA-721 N59EJones Daniel S · Panama City Beach, FLBuilt 1956 · S/N BA-206 N5BACarlsbad Raceway Corp · Hemet, CABuilt 1962 · S/N BA-614 N5QQBowe Walter C Trustee · Sonoma, CABuilt 1946 · S/N A-223 N6000MValiair Limited Co Trustee · Casper, WYBuilt 1965 · S/N BA-727 N60493Cam Air · Caldwell, IDS/N 52-10960 N606JWHeartland Aviation Inc · Alliance, NES/N AF-895 N606PARegistration Pending · Kingsford, MIRegistration pendingBuilt 1952 · S/N 52-10897 N6100CErickson Kirk E · Warroad, MNS/N 51-11532 N611WPScilleppi Gregory · Bainbridge Island, WABuilt 1952 · S/N AF-875

Back to AD 72-16-02 R3