Registered aircraft · 29

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

N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140 N101VSCalspan Corporation · Buffalo, NYBuilt 1969 · S/N 218 N123DGDavis Air LLC · Vero Beach, FLBuilt 1976 · S/N 342 N165CMUS Crane LLC · Wilmington, DES/N 355 N175FSJet Set 1 LLC · Kalispell, MTBuilt 1965 · S/N 031 N193DBDakota Territory Air Museum · Minot, NDS/N 193 N1965LMuseum Of Flight Foundation · Seattle, WABuilt 1965 · S/N 012 N237TWTechnical Education Services Inc DBA · Virginia Beach, VABuilt 1970 · S/N 237 N249HPSale Reported · Camden, DESale reportedBuilt 1975 · S/N 301 N24SAviation Sales And Charter LLC · Dover, DES/N 297 N24SAClark Lloyd E · Hanover, MDS/N 24-117 N24WXTre Aviation Corp · Wilmington, DEBuilt 1966 · S/N 101 N27BJCbg LLC · Wilsonville, ORBuilt 1971 · S/N 227 N293MCTechnical Education Services Inc DBA · Virginia Beach, VABuilt 1974 · S/N 24-293 N295NWAmerican Trans Air T/A · Phoenix, AZBuilt 1974 · S/N 295 N3137Avstar Inc · Seattle, WABuilt 1966 · S/N 123 N352MDDolphin Aviation LLC · Tulsa, OKBuilt 1977 · S/N 352 N400MSMil Oh LLC · Camden, DEBuilt 1972 · S/N 246 N45ED45ed LLC · Calhoun, GABuilt 1966 · S/N 104 N48CTBank Of Utah Trustee · Salt Lake City, UTBuilt 1973 · S/N 274 N49GSAvstar Inc · Seattle, WABuilt 1976 · S/N 336 N555LJBeck Angelique Verschuur · Ione, CAS/N 195 N56MMCarlisle Air LLC · Locust Valley, NYBuilt 1976 · S/N 332 N68LULewis University · Romeoville, ILBuilt 1968 · S/N 163 N701SCAntares Aviation LLC · Boca Raton, FLS/N 24D-235 N711CWPremier Jets Inc · Hillsboro, ORBuilt 1965 · S/N 055 N721SFSpirit Of Flight Foundation · Nampa, IDBuilt 1976 · S/N 325 N7701LLopez Fabio A · Denver, NCS/N 288 N894CJCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1976 · S/N 335

Back to AD 84-17-02