Registered aircraft · 40,473

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

N4381SPilatus Aircraft USA Ltd · Broomfield, COBuilt 1984 · S/N 28-8590014 N4382JGood Flight Aviation LLC · Stockton, CABuilt 1984 · S/N 28-8516018 N4382QLegends Air LLC · Wilmington, DES/N 17260282 N4382RMoranski Joseph F · Budd Lake, NJBuilt 1974 · S/N 17263132 N4382TGray Robert C · Dalton, MNBuilt 1971 · S/N 28-7205153 N4382ZFlerlage Katy Anne · Maple Hill, KSBuilt 1968 · S/N 18-8706 N43836Robinson Marissa · Burgettstown, PABuilt 1977 · S/N 28-7890026 N43839Legacy Aviation LLC · Sullivan, INBuilt 1984 · S/N 28-8590020 N4383FRed Tail Scholarship Foundation · Tuskegee, ALBuilt 1976 · S/N 28-7790025 N4383PBeard Michael L · Marble Hill, MOS/N 23-1893 N4383QBladen Aviation Inc · Elizabethtown, NCBuilt 1971 · S/N 17260283 N4383ZBredthauer Glen E · Hastings, NEBuilt 1968 · S/N 18-8683 N43843Koenig David J · Crosslake, MNBuilt 1977 · S/N 28-7890028 N4384AJourneys Aviation Inc · Boulder, COBuilt 1956 · S/N 18-4792 N4384FEes LLC · Thomaston, CTS/N 28-7790026 N4384JBennett Nicholas C · England, ARBuilt 1967 · S/N 28-22771 N4384QMorten John E · Larimore, NDBuilt 1971 · S/N 17260284 N4384RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263134 N4384ZSilent Knights Inc · Ankeny, IAFirst renewal noticeBuilt 1968 · S/N 18-8685 N4385BDorris Michael R · Mccall, IDBuilt 1956 · S/N 26729 N4385GSouthwind Global Aviation Inc · Moundridge, KSBuilt 1985 · S/N 28-8590045 N4385MCowlin Christopher S · Hollywood, SCBuilt 1984 · S/N 28-8590025 N4385QKulis Richard W · Gill, MABuilt 1971 · S/N 17260285 N4385RAnderson Kenneth J · Norman, OKBuilt 1974 · S/N 17263135 N4385WMacair Aviation LLC · Xenia, OHBuilt 1984 · S/N 28-8516002 N4386AShannon Christopher R · Nome, AKS/N 18-4794 N4386JMeerwarth John J Jr · Eagle Bridge, NYS/N 28-22774 N4386LTuck Kevin · Chico, CAS/N 1346 N4386MPerez Gabriel R · Dripping Springs, TXBuilt 1985 · S/N 28-8590027 N4386RFlying H LLC · Lake Placid, FLBuilt 1974 · S/N 17263136 N4386TTango 86 LLC · Stuart, FLBuilt 1971 · S/N 28-7105221 N4386ZBallard David L Trustee · Chugiak, AKBuilt 1968 · S/N 18-8708 N4387AMcgahan Cody · Nikiski, AKBuilt 1956 · S/N 18-4795 N4387JSparetime Aviation LLC · Belle Plaine, MNBuilt 1967 · S/N 28-22775 N4387PAurora 17 Holdings LLC · Aurora, ORBuilt 1960 · S/N 23-1898 N4387QCrose Merrill L · Sibley, MOBuilt 1971 · S/N 17260287 N4387TSkystat LLC · Forney, TXBuilt 1972 · S/N 28-7205155 N43885Paris Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8516032 N4388AVan Wagner Aerial Media LLC · Pembroke Pines, FLBuilt 1956 · S/N 18-4796 N4388CAlbert Lea Airport Inc · Albert Lea, MNBuilt 1984 · S/N 28-8516021 N4388JJohnson Kurt A · South Weber, UTS/N 28-22778 N4388RSunrise Aviation Inc · Ormond Beach, FLBuilt 1974 · S/N 17263138 N4388TClear Skies Aviation Inc · Montgomery, TXBuilt 1971 · S/N 28-7205156 N4388ZWooliver Steve P · Wasilla, AKFirst renewal noticeBuilt 1968 · S/N 18-8714 N43899Smtm Holdings Inc · Wilmington, DEBuilt 1985 · S/N 28-8516033 N4389FFarooqi Muhammad M · Plano, TXS/N 28-7725013 N4389QMellinger Jason C · North Pole, AKS/N 17260289 N4389TBurchett James W · Seabeck, WABuilt 1972 · S/N 28-7205157 N4389VLeonard Nicholas Robert Eugene · Monument, COBuilt 1985 · S/N 28-8590028 N4389ZZaczkowski Paul S · Tok, AKBuilt 1968 · S/N 18-8716

Back to AD 80-04-03 R2