Registered aircraft · 130

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:96-09-08-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:96-09-08-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:96-09-08-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:96-09-08-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:96-09-08-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:96-09-08-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.

N787PDDougherty Paul · Bethel, PAS/N 5318 N79AVRegistered aircraftBuilt 1986 · S/N 5114 N79DLattanzi James A · Atco, NJBuilt 1992 · S/N 5260 N7EHHalimi Timothy · Bell, CABuilt 1994 · S/N 5314 N7XXAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1991 · S/N 5221 N808JPPruzek Joshua W · West Linn, ORBuilt 1993 · S/N 5278 N80ASAlpha Sierra LLC · Simi Valley, CABuilt 1992 · S/N 5244 N80WSMh Aviation LLC · Foster City, CABuilt 1994 · S/N 5304 N811RMForero Christopher · Mercerville, NJBuilt 1995 · S/N 5332 N812BLLett Robert W · Dallas, TXBuilt 1997 · S/N 5356 N822PGottschall Kenneth Lee III · Santa Paula, CAS/N 5341 N846Davis Hedley C · Middletown, DEBuilt 1992 · S/N 5257 N84PSValiair Lc Trustee · Casper, WYBuilt 1983 · S/N 5031 N87WYCarter Mark E · Salem, VABuilt 1986 · S/N 5111 N912STAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1994 · S/N 5298 N913STRuff Randall N · Bay City, MIBuilt 1992 · S/N 5258 N916Kyer Barry Patrick · Honey Grove, TXBuilt 1994 · S/N 5316 N92BTUnadventurous LLC · Amarillo, TXBuilt 1992 · S/N 5262 N92TPPearce Michael Brett · Garner, NCBuilt 1992 · S/N 5246 N92WSFlyboy 71 LLC · Kalamazoo, MIBuilt 1992 · S/N 5236 N931Registered aircraftBuilt 1993 · S/N 5297 N933STSaratina Inc · Calhoun, GABuilt 1994 · S/N 5299 N974Mulligan Shawn P · Katy, TXBuilt 1993 · S/N 5281 N97TJFisher Kurt Adrian Trustee · San Luis Obispo, CAS/N 5069 N98REverything Pitts LLC · Queen Creek, AZBuilt 1992 · S/N 5261 N995KGStick N Rudder LLC · Wilmington, DES/N 5226 N99JPCp Aviation Inc · Santa Paula, CAS/N 5101 N99MFWelkin Aero Inc · Garden Plain, KSBuilt 1982 · S/N 3004 N9QTJakes Airventures LLC · Carmel, CABuilt 1997 · S/N 5354 N9YHHiemstra Andrew · Tuolumne, CABuilt 1996 · S/N 5348

Back to AD 96-09-08 R1