Registered aircraft · 70

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:2001-24-07-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:2001-24-07-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:2001-24-07-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:2001-24-07-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:2001-24-07-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:2001-24-07-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.

N7ADEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11098 N7UCTristate Care Flight LLC · Greenwood Village, COBuilt 2000 · S/N 11088 N80NYWgb Holdings LLC · Sparta, NJS/N 11214 N820FTBristow LLC · Lake Charles, LABuilt 2007 · S/N 11701 N827KUEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11609 N85KVKhosla Ventures LLC · San Jose, CABuilt 2002 · S/N 11145 N897BCIntersouth Inc · Santo DomingoS/N 7631 N901CMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11611 N901EMLifeflight Of Maine LLC · Bangor, MEBuilt 2004 · S/N 11614 N901HCIhc Health Services Inc DBA · Salt Lake City, UTBuilt 1988 · S/N 10033 N910LBBristow LLC · Lake Charles, LABuilt 2006 · S/N 11682 N91LFInternational Defense & Aerospace Group LLC · Glen Mills, PABuilt 2002 · S/N 11509 N91SVSaint Vincent Mercy Medical Center · Toledo, OHS/N 11627 N921LFLife Flight Network LLC · Aurora, ORBuilt 2002 · S/N 11142 N922LFEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11149 N923LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2003 · S/N 11220 N92LFEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2004 · S/N 11604 N94AHEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2000 · S/N 11081 N95RZSt Vincent Mercy Medical Center · Toledo, OHBuilt 2002 · S/N 11147 N9CWGran Cosecha LLC · Lake Wales, FLBuilt 2008 · S/N 11732

Back to AD 2001-24-07 R1