Registered aircraft · 19

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:2008-02-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:2008-02-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:2008-02-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:2008-02-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:2008-02-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:2008-02-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.

N10MYBoston Executive Helicopters LLC · Norwood, MABuilt 1991 · S/N 5500 N167MTAnalar Corp · Princeton, NJS/N 5604 N355ARCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2004 · S/N 5213 N355ERElite Rotorcraft LLC · Mt Juliet, TNBuilt 1990 · S/N 5436 N355HRNext Level Aviation LLC · Pflugerville, TXBuilt 1991 · S/N 5473 N355JCMavana As LLC · Miami, FLS/N 5517 N355NSNs Air Leasing LLC · Wilmington, DES/N 5682 N35JPEleven 11 Ventures LLC · Helena, MTBuilt 1993 · S/N 5562 N52ZXRichard Schuman LLC · Kailua, HIS/N 5515 N624ADEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5656 N624TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5459 N625CLMansfield Heliflight Inc · Milton, VTS/N 5545 N627TDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 5460 N642ABCatalyst Aviation LLC · Hammonton, NJBuilt 1991 · S/N 5498 N712CACatalyst Aviation LLC · Hammonton, NJBuilt 1987 · S/N 5362 N713CACatalyst Aviation LLC · Hammonton, NJS/N 5363 N718WAWings Air Helicopters LLC · West Harrison, NYS/N 5695 N808FXN808fx LLC · Kalispell, MTS/N 5438 N887LHHp Aviation Inc · Oldsmar, FLS/N 5622

Back to AD 2008-02-10