Registered aircraft · 30

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:92-15-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:92-15-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:92-15-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:92-15-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:92-15-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:92-15-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.

N103HCEstar Aerospace Corp · Columbus, OHS/N A068 S.A.N215TPMiddle Tennessee State University · Murfreesboro, TNS/N RJ-64 N250GPCsds Aircraft Sales & Leasing Inc · Rllng Hls Est, CABuilt 1984 · S/N A069 S.A.N2WCEstar Aerospace Corp · Columbus, OHS/N A047 S.A.N301AEUnlimited Boat Sales Inc · Page, AZS/N A091 S.A.N369EASchool Of Missionary Aviation Technology · Ionia, MIBuilt 1985 · S/N RJ-2 N37CBChexair LLC · Miami, FLS/N A035 S.A.N398BBDodson International Parts Inc · Rantoul, KSBuilt 1988 · S/N RJ-39 N399DMSolomon Mark Trustee · Wilmington, DEBuilt 1980 · S/N A008 S.A.N400GKCentral Virginia Aviation Inc · Petersburg, VABuilt 1982 · S/N A019 S.A.N400HH400hh Inc · Oldwick, NJS/N A025 S.A.N400UFNova Jets USA Corp · Orlando, FLS/N A022 S.A.N405MGKm Operations LLC · Alpharetta, GABuilt 1982 · S/N A021 S.A.N418CTMmu Aviation LLC · West Orange, NJBuilt 1988 · S/N RJ-42 N425BJDodson International Parts Inc · Rantoul, KSBuilt 1987 · S/N RJ25 N442EAAziz Walid George Haddad · San Antonio, TXBuilt 1983 · S/N A058SA N44MMMike Moser Inc · Wilmington, DEBuilt 1984 · S/N A080 S.A.N520WSMmu Aviation LLC · West Orange, NJBuilt 1988 · S/N RJ-53 N600GWG3x Aerospace Inc · Dover, DES/N A044S.A.N60EFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1984 · S/N A070SA N655CMWoodland Ranch LLC · Odessa, MOBuilt 1986 · S/N RJ-17 N65RASky Cloud Ventures LLC · Seagrove Beach, FLS/N RJ-9 N765KCJetset LLC · Denison, TXBuilt 1984 · S/N A079 S.A.N777FEUnlimited Boat Sales Inc · Page, AZS/N RJ-30 N88UACentral Virginia Aviation Inc · Petersburg, VABuilt 1988 · S/N RJ-49 N8YMBeechjet Aviation Inc · Marietta, GABuilt 1985 · S/N RJ-04 N907JEDestiny Venture LLC · Brownsville, TXBuilt 1995 · S/N RK-107 N907MXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1983 · S/N A036 S.A.N922TRCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1988 · S/N RJ44 N94LDSky Aviation Holdings LLC · Pompano Beach, FLBuilt 1984 · S/N A073 S.A.

Back to AD 92-15-02