Registered aircraft · 33

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:94-22-10-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:94-22-10-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:94-22-10-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:94-22-10-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:94-22-10-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:94-22-10-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.

N193SJFrontera Flight Holdings Inc · Dover, DES/N 193 N330ENUniversal Hydrogen Co · Hawthorne, CABuilt 1991 · S/N 274 N539ARBank Of Utah Trustee · Salt Lake City, UTS/N 539 N560WKBank Of Utah Trustee · Salt Lake City, UTS/N 560 N563AWUS Department Of State · Melbourne, FLS/N 563 N567WKUS Dept Of State · Melbourne, FLS/N 567 N568AWUS Department Of State · Melbourne, FLS/N 568 N569AWUS Department Of State · Melbourne, FLS/N 569 N570AWBank Of Utah Trustee · Salt Lake City, UTS/N 570 N580ARBank Of Utah Trustee · Salt Lake City, UTS/N 580 N589AWBank Of Utah Trustee · Salt Lake City, UTS/N 589 N599ARBank Of Utah Trustee · Salt Lake City, UTS/N 599 N619GNBank Of Utah Trustee · Salt Lake City, UTBuilt 1995 · S/N 415 N706XTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 505 N800AWUS Department Of State · Melbourne, FLS/N 573 N804MRUS Department Of Homeland Security · Washington, DCS/N 374 N807EXFrontera Flight Holdings Inc · Dover, DEBuilt 1991 · S/N 292 N807MRUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 663 N808MRUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 667 N8100LDynamic Avlease Inc · Bridgewater, VABuilt 1989 · S/N 146 N8100VDynamic Avlease Inc · Bridgewater, VABuilt 1985 · S/N 024 N810MRUS Department Of Homeland Security · Washington, DCS/N 590 N8300GUS Special Operations Command · Tampa, FLBuilt 1991 · S/N 298 N837EXBank Of Utah Trustee · Salt Lake City, UTS/N 217 N839EXBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 226 N884EATvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1994 · S/N 387 N888XKDodson International Parts Inc · Rantoul, KSS/N 264 N891EATvpx Ars Inc Trustee · North Salt Lake, UTS/N 335 N984HANorthrop Grumman Systems Corp · El Segundo, CABuilt 1994 · S/N 377 N990AVBank Of Utah Trustee · Salt Lake City, UTBuilt 1988 · S/N 099 N990BHBig Horn Airways Inc · Sheridan, WYBuilt 1991 · S/N 265 N991BHBig Horn Airways Inc · Sheridan, WYBuilt 1992 · S/N 324 N992BHBig Horn Airways Inc · Sheridan, WYBuilt 1991 · S/N 258

Back to AD 94-22-10 R1