Registered aircraft · 20

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

N10YYTaifun LLC · Ithaca, NYBuilt 1986 · S/N 1092 N11VRUltraflight LLC · Wilmington, DEBuilt 1984 · S/N 1033 N170TTNielsen James Patrick · Chugiak, AKBuilt 1985 · S/N 1043 N175WCKays Villa Flyers Inc · Kaysville, UTS/N 1025 N17NTIreland Robert C · Mount Shasta, CAS/N 1046 N292TEFox James E · Queen Creek, AZBuilt 1985 · S/N 1056 N321SSShort Jeffrey P · Massapequa Park, NYBuilt 1984 · S/N 1030 N33GBTaylor Alexander R · Anchorage, AKS/N 1065 N36MALeffler Allen L · Santa Margarita, CAS/N 1040 N440WQWagenknecht Harold H · Ruther Glen, VABuilt 1986 · S/N 1087 N5ZDBurns Craft LLC · Wilmington, DES/N 1069 N65MAStofman Daniel M · Whitehouse Station, NJBuilt 1984 · S/N 1012 N66BVSmith James E Trustee · Kalispell, MTS/N 1070 N66RFZero Sink Inc · Wilmington, DES/N 1112 N67LMHartmann Michael R · Santa Barbara, CAS/N 1095 N721DMDavis Gary J · Murphy, NCBuilt 1983 · S/N 1005 N76BPStewart Michael · Park City, UTBuilt 1984 · S/N 1034 N777MABb Lsa Aviation Inc · Wilmington, DES/N 1038 N95CSLert Peter S · Graton, CAS/N 1047 N9MAActualized Business Solutions Inc · California, MDS/N 1090

Back to AD 2004-20-10