Registered aircraft · 17,028

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.

N9452MSoares De Matos Guilherme Cesar · Fort Lauderdale, FLBuilt 1970 · S/N 21059352 N9461GMillionair Inc · Ferndale, WAS/N U20601661 N9461MMaster Chief Cricket LLC · Morgan City, LABuilt 1970 · S/N 21059361 N9465GOsprey Air LLC · Anchorage, AKS/N U20601665 N9467MSideropoulos Lester G · Knoxville, TNBuilt 1968 · S/N 18258909 N9469GGolf Tango Air Racing LLC · Ephrata, WABuilt 1971 · S/N U20601669 N9470GDrean Gary T · Rancho Santa Fe, CABuilt 1971 · S/N U20601670 N9470MJanes Dwayne O · Edmond, OKBuilt 1970 · S/N 21059370 N9473MOpie Milton J III · White Lake, MIBuilt 1970 · S/N 21059373 N9479GCox Ramona T · Manhattan Beach, CABuilt 1971 · S/N U20601679 N9486GAndrew Odean T · Willow, AKBuilt 1971 · S/N U20601686 N948RRed Baron LLC · Middletown, DEBuilt 1978 · S/N 177RG1318 N9490YKearins John M · North Hampton, NHBuilt 1969 · S/N 20700110 N9497MJomama Aviation LLC · Kalispell, MTBuilt 1970 · S/N 21059397 N9498MVoorhies Jon · Atascadero, CABuilt 1970 · S/N 21059398 N9499GT F T LLC · Hayden, IDBuilt 1971 · S/N U20601699 N949VWCates Byron S · Ronan, MTBuilt 1967 · S/N 18258156 N94CAYoung James W · Seattle, WABuilt 1966 · S/N 17254435 N94HDFreed Philip B · Parkland, FLBuilt 1965 · S/N 18256368 N94TSPetersen Andrew John · Saint Paul, MNS/N 17259814 N9522CToornburg Van W · College Grove, TNBuilt 1969 · S/N 18260111 N952RFArk Aviation LLC · Ladson, SCS/N 18259034 N955CCN955cc LLC · Estero, FLBuilt 1969 · S/N 17258826 N956BFMpd2 Inc · Valdosta, GABuilt 1971 · S/N 18260597 N958BCBranson William E · Mooresville, NCS/N 15069902 N959AGGrant Altin C · Tahlequah, OKBuilt 1973 · S/N 17701952 N959RMLargent Richard B · Southport, NCBuilt 1970 · S/N 17259113 N95AFNeville William J III · Marianna, FLBuilt 1971 · S/N 177RG0126 N95PYJayviation Inc · Lake City, FLBuilt 1964 · S/N 21058514 N96024Strite Jaylon · Cochise, AZS/N R172-0148 N96061Wold Wayne T · Wasilla, AKFirst renewal noticeS/N R1720089 N96177B2 Cpr Plus Inc · Bermuda Dunes, CABuilt 1970 · S/N 17701543 N96218Link Jessica Elizabeth · Castalia, OHBuilt 1967 · S/N R172-0214 N962AFSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1974 · S/N 177RG0464 N962AMInternational Air Services Inc · Carson City, NVBuilt 1976 · S/N 177RG1054 N962RGBoucher John C · Lakeside, AZBuilt 1967 · S/N U206-0957 N9640QFour Zero Quebec Inc · Cheyenne, WYBuilt 1969 · S/N 18259642 N965SCoverdale Mark E · Folsom, CABuilt 1969 · S/N 18259638 N966STAbc Builders LLC · Merritt Island, FLBuilt 1966 · S/N 18256972 N967AAWings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17260393 N96890Llewellyn James R · Bainbridge Island, WAS/N R172-0118 N968HCMarsh Flying Services LLC · El Dorado, KSBuilt 1971 · S/N 17259752 N969RBK Fortner LLC · San Marcos, TXBuilt 1968 · S/N U206-1061 N9711AJones Stanley A · Benkelman, NEBuilt 1969 · S/N 18260098 N971AAHobgood David · Bartow, FLBuilt 1966 · S/N 15065572 N9720RPca Tail One LLC · Wilmington, DEBuilt 1968 · S/N 18258836 N972DPCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258652 N972LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1967 · S/N U2060705 N972MAAir Repair Inc · Easton, MDBuilt 1967 · S/N 15067551 N972NCIal Corp · Lewes, DEBuilt 1971 · S/N 17259818

Back to AD 72-03-03 R3