Registered aircraft · 26,231

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.

N2826EBennett Randy A · Hickman, CABuilt 1946 · S/N 7AC-6409 N2826KFallbrook Air Service Inc · Fallbrook, CABuilt 1947 · S/N 5553 N2826LJamtori Investments LLC · Forrest City, ARS/N 17256026 N2826UJohnson James E · College Station, TXBuilt 1963 · S/N 17250426 N28273Hicks Joseph O · Germanton, NCBuilt 1940 · S/N 4664 N2827KHagedorn Matthew J · Prineville, ORBuilt 1947 · S/N 5554 N28285Bent James L Jr DBA · Palatine Bridge, NYS/N 4672 N2829LGeaux Fly LLC · Bossier City, LAS/N 17256029 N2829NPeterson William P · Keller, TXBuilt 1947 · S/N 13090 N2830HPowell Sherman B III · Pulaski, TNBuilt 1946 · S/N 3455 N2830LPilotpros Training LLC · Longview, TXBuilt 1967 · S/N 17256030 N2830NHanke Peter W · Chimacum, WABuilt 1947 · S/N 13091 N2831CMohar Fred B Jr · Turner, MTBuilt 1954 · S/N 26374 N2831LJkj Flying LLC · Chittenango, NYBuilt 1967 · S/N 17256031 N2831USchmidt Paul D · Whitesburg, GABuilt 1963 · S/N 17250431 N2832CVandehei Linda I · Fairbanks, AKBuilt 1954 · S/N 26375 N2832KBalogh Andrew · Wellington, FLFirst renewal noticeBuilt 1947 · S/N 5559 N2832SMeyer Philipp J · Sioux Falls, SDBuilt 1967 · S/N 15066732 N2832URegistration Pending · Wasilla, AKRegistration pendingS/N 17250432 N2833LWade Kenneth L · Huron, TNBuilt 1967 · S/N 17256033 N2834LRomano Kenneth J · Shirley, NYBuilt 1967 · S/N 17256034 N2834NPoland Marvin W · Tawas City, MIBuilt 1947 · S/N 13095 N2834SMcmahon Connor J · Brookfield, CTBuilt 1967 · S/N 15066734 N28355Hayton James B · Sedro Woolley, WABuilt 1950 · S/N 15579 N2835CTroutman Charles W · Prineville, ORFirst renewal noticeBuilt 1954 · S/N 26378 N2835LBrinkmac LLC · Cadillac, MIS/N 17256035 N2835SDuyck Candace A · Cornelius, ORS/N 15066735 N2836LRyan Patrick J · Quinton, VABuilt 1967 · S/N 17256036 N2836USolymanbeyk Willard · Modesto, CABuilt 1963 · S/N 17250436 N2837CPerris Valley Skydiving School Inc · Perris, CABuilt 1954 · S/N 26380 N2837DZielinski John · Queen Creek, AZBuilt 1949 · S/N 15346 N2837LGehrke Halle · Elk Mound, WIBuilt 1967 · S/N 17256037 N2837NWells Mark A · Monroe, WIS/N 13098 N2837SBuric Ivan · Panama City, FLBuilt 1967 · S/N 15066737 N2837VLewis Samuel Joseph · Decatur, TXBuilt 1974 · S/N 15076296 N2838LA-R-M Aircraft Leasing LLC · Williamsburg, VABuilt 1967 · S/N 17256038 N2838SLewallen Roy W · Beaverton, ORBuilt 1967 · S/N 15066738 N2838UCag Farms Inc · Angier, NCS/N 17250438 N2839CRegistered aircraftBuilt 1954 · S/N 26382 N2839NTristar Aviation Services LLC · Hendersonville, TNBuilt 1947 · S/N 13100 N2839SVon Trapp Ryan G · Charlotte, NCBuilt 1967 · S/N 15066739 N2839UEttelson Michael J · New Hampton, NHBuilt 1963 · S/N 17250439 N2840JDarnell Joseph D · Anchorage, AKBuilt 1959 · S/N 56339 N2840UDejong Robert W · Austin, TXBuilt 1963 · S/N 17250440 N2841CMonckton Geary S · Alvin, TXBuilt 1954 · S/N 26384 N2841EEllingson Leslie B · Harwood, NDBuilt 1946 · S/N 7AC-6424 N2841LJustison David · Hillsboro, ILS/N 17256041 N2842CCollins Michael P · Ballwin, MOBuilt 1954 · S/N 26385 N2842LBravo Aviation LLC · Rexburg, IDBuilt 1967 · S/N 17256042 N2842SRegistration Pending · Mountain Home, ARRegistration pendingBuilt 1967 · S/N 15066742

Back to AD 94-05-05 R1