Registered aircraft · 26,232

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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  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:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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.

N7162XJim L. Rentz · Bainbridge, GABuilt 1961 · S/N 15059262 N71632Landsgaard Theodore J · Rosamond, CABuilt 1946 · S/N 3059 N7163FTomac Steven B · Yerington, NVBuilt 1966 · S/N 15063763 N7163TPeoble Douglas M · Tucson, AZS/N 46763 N7164AKiever Robert P Jr · Summerland Key, FLBuilt 1956 · S/N 29264 N7164FShear View Mulching LLC · Poplarville, MSBuilt 1966 · S/N 15063764 N7164SGardner Terrence L · Pittsboro, NCFirst renewal noticeBuilt 1967 · S/N 15067864 N7164TT Aviation Services Inc · Canovanas, PRBuilt 1959 · S/N 46764 N7165FOlson Eric C · Portland, ORBuilt 1966 · S/N 15063765 N7165MKofoed Keith L · Moses Lake, WAS/N 55465 N7165SCaskey Martin K · Paso Robles, CABuilt 1967 · S/N 15067865 N7166AHuseth William Greg · Pooler, GABuilt 1956 · S/N 29266 N7166BWard Joseph C · Anchorage, AKBuilt 1956 · S/N 18-5193 N7166FRegistration Pending · Kenly, NCRegistration pendingS/N 15063766 N7166TCentral Aviation LLC · White City, ORBuilt 1959 · S/N 46766 N7167ATucker Tim · Hopkinsville, KYBuilt 1956 · S/N 29267 N7167FSteinhoff Daniel P · Santa Rosa, CABuilt 1966 · S/N 15063767 N7167XMckissack Douglas R · Pooler, GABuilt 1961 · S/N 15059267 N71681Lindstrom Bruce C · Sinclairville, NYS/N 7AC-4176 N7168SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15067868 N7169TBrent Ephron D · Arriba, COBuilt 1959 · S/N 46769 N7170BZimniewicz Matthew J · River Falls, WIBuilt 1956 · S/N 18-5200 N7170XMccardle Guy D · Burnham, PABuilt 1961 · S/N 15059270 N71715Gelbart Uriel A · Anchorage, AKS/N 3142 N7171DClement Aircraft LLC · Anchorage, AKBuilt 1957 · S/N 18-5629 N7172SLovaas Darryl G Trustee · Crescent City, CABuilt 1967 · S/N 15067872 N71730Shipley John L · Tremonton, UTS/N 3157 N7173ADuke Billy L · Ormond Beach, FLBuilt 1956 · S/N 29273 N7173MCronin Larry D · Mountain Home, IDBuilt 1958 · S/N 55473 N7173TDidier Thomas · Port Washington, WIS/N 46773 N7174ABertrand Jeff J · Willow, AKBuilt 1940 · S/N 5908 N7174SBelasco Thomas D II · Bridgeport, WVBuilt 1967 · S/N 15067874 N7174TPaddock Spencer · Palmer, AKBuilt 1960 · S/N 46774 N7174XMcdaniel John P III · Marianna, FLS/N 15059274 N7175DSale Reported · Brainerd, MNSale reportedBuilt 1957 · S/N 18-5634 N7175FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063775 N7175TTischer William D · Shoreview, MNBuilt 1959 · S/N 46775 N71768Mcalee Patrick J · Chicago, ILBuilt 1946 · S/N 3195 N7176TRabe Robert · Elk Grove, CAS/N 46776 N7177MErnst Thaine S · Fallon, NVBuilt 1958 · S/N 55477 N7177SGambell Jesse D · Mulino, ORFirst renewal noticeS/N 15067877 N7177TLefevers Adam · Pineville, KYS/N 46777 N7178Beaty Andrew R Jr · Wichita Falls, TXBuilt 1971 · S/N 511 N7178SMcclain Matthew S · Yelm, WABuilt 1967 · S/N 15067878 N7178TGouin Cristina Clara · Fort Pierce, FLBuilt 1959 · S/N 46778 N7179KMattes Michael A · Churubusco, INS/N WH-2 N7179XMcmillan Sharon Mobley · Newnan, GABuilt 1961 · S/N 15059279 N717ABFalls Larry W · Morganton, NCBuilt 2021 · S/N 717 N717RCDmac Aircraft LLC · Savannah, GAS/N 36346 N717SXRegistration Pending · Monhans, TXRegistration pendingBuilt 1959 · S/N 17453

Back to AD 94-05-05 R1