Registered aircraft · 1,068

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:2010-26-05-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:2010-26-05-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:2010-26-05-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:2010-26-05-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:2010-26-05-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:2010-26-05-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.

N98RPPollyannaism LLC · Sheridan, WYBuilt 2002 · S/N 186 N98YCHunter Aviation International Inc · Newark, DEBuilt 1996 · S/N 11 N990LTLife Time Fitness Inc · Chanhassen, MNBuilt 1988 · S/N 60 N990PMBlue Sky Aviation Group LLC · Oakwood, OHBuilt 2000 · S/N 70 N990WJIsland Aviation 900ex LLC · Houston, TXBuilt 2007 · S/N 190 N990WMBear Cub Aviation LLC · Billings, MTBuilt 1998 · S/N 40 N990WRBam Aviation LLC · Jupiter, FLS/N 126 N991CLEagle Shares LLC · Waterford, MIBuilt 2001 · S/N 163 N992CEEagle Shares LLC · Waterford, MIBuilt 2003 · S/N 10 N993CEBarton Malow Holdings LLC · Waterford, MIBuilt 2004 · S/N 208 N993GHXpert Design And Construction LLC · Louisville, KYBuilt 2016 · S/N 736 N995CELuna Aviation LLC · Waterford, MIBuilt 2013 · S/N 262 N999PMPacific Marine Leasing LLC · Jackson, WYBuilt 2019 · S/N 317 N999XB2022 LLC · Wilmington, DEBuilt 2007 · S/N 179 N99RJAlways On Vacation LLC · Sheridan, WYBuilt 2002 · S/N 166 N9CUJani King International Inc · Addison, TXBuilt 1987 · S/N 19 N9GBCardinal Capital Partners Inc · Dallas, TXBuilt 2009 · S/N 624 N9TEAlliance Aviation Group LLC · Wilmington, DEBuilt 1991 · S/N 204

Back to AD 2010-26-05 R1