Skip to content

AD 2001-23-12 R1

Registered aircraft · 66

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-23-12-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-23-12-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-23-12-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-23-12-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-23-12-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-23-12-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.

N185KJJah 2022a Saab340b Msn 185 LLC · Dallas, TXBuilt 1990 · S/N 340B-185 N219KABank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 340B192 N220MJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-220 N253AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-253 N265JAAviation Inventory Resources Inc · Alvarado, TXS/N 340B-265 N266AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-266 N27XJPhoenix Air Group Inc · Cartersville, GABuilt 1985 · S/N 340A-027 N286AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-286 N294TLAviation Inventory Resources Inc · Alvarado, TXBuilt 1997 · S/N 340B-294 N298AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-298 N304AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 340B-304 N304AGBank Of Utah Trustee · Salt Lake City, UTS/N 340B-418 N307AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-307 N313AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-313 N3172Bank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N 340B172 N317AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-317 N320AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-320 N323AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-323 N327AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 340B-427 N329AEBank Of Utah Trustee · Salt Lake City, UTS/N 340B-329 N331TBMassachusetts Institute Of Technology · Lexington, MABuilt 1992 · S/N 340B-331 N332AEAviation Inventory Resources Inc · Alvarado, TXS/N 340B-332 N336SABank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 340B-336 N340RCConsumer Aviation Inc · Springfield, MOS/N 340B-340 N342JCAviation Investments Inc · Redondo Beach, CAS/N 340A-030 N346AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B446 N346CJBank Of Utah Trustee · Salt Lake City, UTS/N 340B-346 N348AGAviation Inventory Resources Inc · Alvarado, TXBuilt 1998 · S/N 340B-448 N351AGBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B445 N352CJAviation Inventory Resources Inc · Alvarado, TXBuilt 1993 · S/N 340B-352 N353SABank Of Utah Trustee · Salt Lake City, UTBuilt 1993 · S/N 340B-351 N355CLRegistration Pending · Statesville, NCRegistration pendingS/N 340B-355 N361CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1994 · S/N 340B-361 N362AGJahn362ag LLC · Miami, FLBuilt 1998 · S/N 340B-438 N364PXFloat Alaska Holdings LLC · Pomona, CAS/N 340B-262 N369PXAviation Inventory Resources Inc · Alvarado, TXS/N 340B-295 N399CLBeta Fleet LLC · South Burlington, VTBuilt 1996 · S/N 340B-399 N413XJAviation Inventory Resources Inc · Alvarado, TXBuilt 1997 · S/N 340B413 N417XJBank Of Utah Trustee · Salt Lake City, UTS/N 340B417 N419CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-419 N431BCJahn431bc LLC · Miami, FLBuilt 1991 · S/N 340B-260 N432CLLegends Cargo Aircraft LLC · Lakeland, FLBuilt 1997 · S/N 340B-432 N440CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1998 · S/N 340B-440 N441FFAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1998 · S/N 340B441 N458CLBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 340B-458 N481BCJahn481bc LLC · Miami, FLBuilt 1991 · S/N 340B-274 N631BCIbc Airways Inc · Miami, FLS/N 340A-061 N63AUTurbo Lease LLC · Miami, FLBuilt 1990 · S/N 340B-181 N651BCAviation Inventory Resources Inc · Alvarado, TXS/N 340A-076 N675PAAviation Inventory Resources Inc · Alvarado, TXBuilt 1990 · S/N 340B-206

Back to AD 2001-23-12 R1