Registered aircraft · 32

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

N1010KCooley Joshua · Kenai, AKBuilt 1971 · S/N 2068C N164BMMachtemes Brian A · Minnetonka, MNBuilt 1972 · S/N 2114C N187MTSafer Medical Of Mt Inc · Fort Benton, MTBuilt 2011 · S/N DMO-202 N18PRDenicola Frank · Visalia, CABuilt 1977 · S/N 6198C N199LHDubbert Roger D · Mexico, MOBuilt 2010 · S/N 0045 N20TDBavuso Antonio J · Holt, MOBuilt 2012 · S/N 2081 N241JTCollum Gregg · San Angelo, TXBuilt 2006 · S/N 001 N258WSeignious Russell V · Pass Christian, MSS/N 001 N29FCrawford Everette P · Columbia, LABuilt 1969 · S/N 4-179 N310SHHebron Scott A · Westland, MIBuilt 1971 · S/N 010 N324BAHart John Michael · Olalla, WABuilt 1969 · S/N 2035C N35PXBradley Glen C · Pensacola, FLBuilt 2023 · S/N 35 N366KWPlane Fun Inc Tr Trustee · Snellville, GABuilt 1967 · S/N 383 N38WWBishop Thomas W · Decatur, TXBuilt 1994 · S/N 74555 N4026CNauta Gordon W · Palmdale, CABuilt 1948 · S/N 108-5026 N42MRNeidert Melvin E · Usysses, KSBuilt 1971 · S/N 529-42-2453 N4390RBrown David R · Kent, WABuilt 1974 · S/N 17263140 N47195N47195 LLC · Riverton, WYS/N HB-004 N498XASpringer Larry E · Bothel, WABuilt 1975 · S/N 5049C N50235Hamidi Saeid · Yorba Linda, CAS/N 1038 N503KMNoguess Levi B · Belton, TXS/N 9802138 N55AYSinthunava Nuttapol · Bellevue, WABuilt 1998 · S/N ACB-4 N55KBHall John L · Port Angeles, WAS/N WA-2 N587GWKuber Daniel · Girdwood, AKBuilt 2025 · S/N 907 N601JAMarsh Martin R · Palm Bay, FLBuilt 2018 · S/N 6-6464 N615SDHolland Andrew K · Sterling, AKS/N 2083C N6676PKromer Jeffrey B · Mount Carroll, ILS/N 79N N86988Triple W Metal Building Construction LLC · Weatherford, TXBuilt 1973 · S/N 2137C N9171NBainville Scott L · Asheboro, NCBuilt 2001 · S/N 001 N921AFFoss Tim C · Marine St Crx, MNBuilt 2014 · S/N S9704-0212 N924WFBlue Zone Aviation LLC · Sheridan, WYBuilt 2012 · S/N DM0-291 N926BCAllen Tim R · Holly, MIBuilt 2023 · S/N 685262

Back to AD 2002-18-51