Registered aircraft · 164

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-12-03-R2') 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-12-03-R2') 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-12-03-R2')
    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-12-03-R2')
  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-12-03-R2')
  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-12-03-R2')
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.

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 N9JJPlane Fun Inc Tr Trustee · Snellville, GABuilt 1983 · S/N 1015 N9QTJakes Airventures LLC · Carmel, CABuilt 1997 · S/N 5354 N9YHHiemstra Andrew · Tuolumne, CABuilt 1996 · S/N 5348

Back to AD 96-12-03 R2