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.

N388AVUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-188 N390RHAlpine Aviation Inc · Provo, UTS/N U-39 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91 N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2 N4299AUas Transervices Inc · Boca Raton, FLBuilt 1971 · S/N U-146 N450NANational Aerotech Aviation Delaware · Wilmington, DES/N U-92 N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81 N51RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-212 N52RPUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-210 N53RPUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-195 N55RPUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-198 N599CZN599cz LLC · Milwaukee, WIBuilt 1969 · S/N U-89 N62989Uas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-183 N63978Uas Transervices Inc · Boca Raton, FLBuilt 1981 · S/N U-171 N6645KBemidji Aviation Services Inc · Bemidji, MNBuilt 1983 · S/N U-209 N6724DUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-215 N68TAUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-177 N699CZN699cz LLC · Milwaukee, WIBuilt 1968 · S/N U-10 N70NPBemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U-14 N7200ZUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-219 N7207EBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N U-223 N7209WUas Transervices Inc · Boca Raton, FLBuilt 1984 · S/N U-224 N7212PBemidji Aviation Services Inc · Bemidji, MNBuilt 1984 · S/N U-220 N7862RUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-85 N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68 N802BAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-29 N81820Uas Transervices Inc · Boca Raton, FLBuilt 1987 · S/N U232 N8226ZUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-190 N8227PUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-194 N899CAAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-104 N899CZN899cz LLC · Milwaukee, WIS/N U-96 N950AAAlpine Aviation Inc · Provo, UTBuilt 1974 · S/N U-159 N95WAAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U-6 N96AVUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-201 N990AFUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-211 N991AFUas Transervices Inc · Boca Raton, FLS/N U-214 N991AKLake Clark Air Inc · Port Alsworth, AKBuilt 1982 · S/N U-189 N992AFUas Transervices Inc · Boca Raton, FLBuilt 1983 · S/N U-203 N992AKLake Clark Air Inc · Port Alsworth, AKBuilt 1981 · S/N U-167 N993AKLake Clark Air Inc · Ports Alsworth, AKBuilt 1982 · S/N U-180 N994AHAerospace Asset Holdings LLC · Wilmington, DEBuilt 1970 · S/N U141 N997SBUas Transervices Inc · Boca Raton, FLBuilt 1982 · S/N U-192 N999CZN999cz LLC · Milwaukee, WIBuilt 1969 · S/N U116 N999DZAlpine Aviation Inc · Provo, UTBuilt 1968 · S/N U70 N99GHAlpine Aviation Inc · Provo, UTS/N U-112

Back to AD 69-24-02 R3