Skip to content

Registered aircraft · 95

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:69-24-02-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:69-24-02-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:69-24-02-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:69-24-02-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:69-24-02-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:69-24-02-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.

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N104BEUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-221 N106SXUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-166 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N108SXUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-184 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N130GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-222 N131GPUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U225 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60 N172EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-172 N174AVUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-174 N175EEBemidji Aviation Services Inc · Bemidji, MNBuilt 1981 · S/N U-175 N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76 N190WAAmeriflight LLC · Dallas, TXBuilt 1983 · S/N U-207 N191AVUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-191 N191WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U136 N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115 N192WAAmeriflight LLC · Dallas, TXBuilt 1973 · S/N U152 N193SUUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U193 N196WAAmeriflight LLC · Dallas, TXBuilt 1981 · S/N U-179 N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130 N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30 N204AFUas Transervices Inc · Boca Raton, FLS/N U-204 N206AVUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-206 N20FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-111 N213AVDodson International Parts Inc · Rantoul, KSS/N U-213 N216CSAlpine Aviation Inc · Provo, UTBuilt 1983 · S/N U-216 N21FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-117 N221BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-168 N223BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-173 N223CABemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-200 N225BHUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-181 N226BHUas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-182 N227AVUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-227 N228BHUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-229 N230BHUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-233 N236ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U236 N237SLAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U237 N238ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U238 N239ALAlpine Aviation Inc · Provo, UTBuilt 1987 · S/N U239 N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74 N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N330AVUas Transervices Inc · Boca Raton, FLBuilt 1986 · S/N U-230 N34AKUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-105

Back to AD 69-24-02 R3