Registered aircraft · 10,639

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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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:99-01-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.

N8941DMain David W · Blounts Creek, NCBuilt 1958 · S/N 22-6095 N8942DCwynar Scott L · Toledo, OHFirst renewal noticeBuilt 1958 · S/N 22-6100 N8945DSonnenberg Larry L · Huber Heights, OHBuilt 1958 · S/N 22-6103 N894MJWaite Richard H · Sun Valley, IDBuilt 1989 · S/N 1809035 N8951DChadwick Stewart · Yuba City, CABuilt 1958 · S/N 22-6114 N8953DVassal Ministries · North Pole, AKBuilt 1958 · S/N 22-6112 N8954DSandstead Russell L · Columbia, TNS/N 22-6117 N8956CCosper Rodney S · Killeen, TXS/N 18-2934 N8958DPoulton Daniel D · Belton, SCBuilt 1958 · S/N 226121 N895VSpurlock Ricky DBA · Jensen, UTBuilt 1958 · S/N 18-6736 N8960CChristensen Todd S · Wasilla, AKBuilt 1954 · S/N 18-3261 N8963DDoyle Patrick H · Keller, TXBuilt 1958 · S/N 22-6127 N8964CHansen Douglas J · Star Prairie, WIBuilt 1953 · S/N 18-2980 N8964DThomas Daniel C · Shady Shores, TXBuilt 1958 · S/N 22-6128 N8965CMisner Darrell R · Kasilof, AKBuilt 1953 · S/N 18-2945 N8965DSale Reported · Beech Creek, PASale reportedBuilt 1958 · S/N 22-6129 N8966DDodd Robert L · Humboldt, IABuilt 1958 · S/N 22-6130 N8968CDowd John J Jr · Syracuse, KSBuilt 1953 · S/N 18-2978 N8968DCleary Katherine E · Mulberry, FLBuilt 1958 · S/N 22-6132 N8971DThomas James W · Jay, FLBuilt 1958 · S/N 18-6408 N8972DClarke Timothy B · Howard, SDBuilt 1958 · S/N 18-6411 N8973CUrbach Jourdan B · Sherman Oaks, CABuilt 1953 · S/N 22-1557 N8973DSnider Scott E DBA · Turner, MTBuilt 1958 · S/N 18-6412 N8975DGrundy James W · W Greenwich, RIBuilt 1958 · S/N 18-6415 N8976CPetruso Rosemary D Co-Trustee · Saint Louis, MOBuilt 1953 · S/N 22-1554 N8976DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-4887 N8977DWilliams Aircraft LLC · Anchorage, AKBuilt 1956 · S/N 18-5083 N8978CMenke Clint A · Cozad, NEBuilt 1953 · S/N 22-1558 N8978DShuman Cecil R Trustee · Chugiak, AKBuilt 1958 · S/N 18-6418 N8979DBurnett Kris W · Anchorage, AKBuilt 1975 · S/N 18-7509053 N897CTHildebrant Steven C · Newborn, GABuilt 1947 · S/N 11-326 N8982DNorth Sound Aviation Inc · Sedro Woolley, WABuilt 1958 · S/N 18-6377 N8984CBaldwin Alexander L · Saint Charles, MOBuilt 1953 · S/N 22-1560 N8987YHanson William D · Soldotna, AKBuilt 1974 · S/N 18-7409132 N8988CEastin Toby M · Jefferson City, MOS/N 22-1566 N898AMyers D M · Vancouver, WARevoked, canceledBuilt 1951 · S/N 22-202 N8991CSpicer Luke J · Seneca, SCS/N 22-1564 N8991YWaldemar Mojica · Arecibo, PRBuilt 1974 · S/N 18-7409133 N8993DKey James M · Hermiston, ORBuilt 1958 · S/N 18-6397 N8993YAirglas Inc · Anchorage, AKBuilt 1974 · S/N 18-7409135 N8995DGraham William Franklin III · Port Alsworth, AKBuilt 1958 · S/N 18-6403 N8996YJohnk Thomas · LyngbyNon-citizen corporation, flight hours not reportedBuilt 1974 · S/N 18-7409138 N8997DFinley Peter T · Bismarck, NDBuilt 1958 · S/N 18-6405 N89994Lon Aviation LLC · Aspen, COS/N 18-8510 N8999DPadgett Benjamin C · Anchorage, AKBuilt 1958 · S/N 18-6407 N89ZWWyckoff Christopher D · Wasilla, AKBuilt 1975 · S/N 18-7509114 N8BKAeroparatus LLC · Monterey, CABuilt 1977 · S/N 18-7709180 N8DGBrito Manuel · Dillingham, AKBuilt 1960 · S/N 22-7308 N8GZRappe Craig E · Wasilla, AKBuilt 1982 · S/N 18-8209017 N8PPChong Maxim F · Lake Peekskill, NYBuilt 1961 · S/N 22-8234

Back to AD 99-01-05 R1