Skip to content

AD 2006-11-05 R2

Registered aircraft · 248

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:2006-11-05-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:2006-11-05-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:2006-11-05-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:2006-11-05-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:2006-11-05-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:2006-11-05-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.

N34137United Airlines Inc · Chicago, ILBuilt 1999 · S/N 30229 N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284 N41140United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30353 N419UPUnited Parcel Service Co · Louisville, KYBuilt 1990 · S/N 23906 N425UPUnited Parcel Service Co · Louisville, KYBuilt 1991 · S/N 25370 N436UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25467 N437UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25468 N438UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25469 N439UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25470 N440UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 25471 N441UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27386 N442UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27387 N443UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27388 N444UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27389 N446UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27735 N447UPUnited Parcel Service Co · Louisville, KYBuilt 1994 · S/N 27736 N448UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27737 N449UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27738 N450UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25472 N451UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 27739 N452UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25473 N453UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25474 N454UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25475 N455UPUnited Parcel Service Co · Louisville, KYBuilt 1995 · S/N 25476 N456UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 25477 N457UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 25478 N458UPUnited Parcel Service Co · Louisville, KYBuilt 1996 · S/N 25479 N459UPCc & Ei LLC · Louisville, KYBuilt 1996 · S/N 25480 N460UPC C & E I LLC · Louisville, KYBuilt 1996 · S/N 25481 N461UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 28265 N463UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 28267 N465UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 28269 N466UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25482 N467UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25483 N468UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25484 N469UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25485 N470UPUnited Parcel Service Co · Louisville, KYBuilt 1997 · S/N 25486 N471UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 28842 N472UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 28843 N473UPUnited Parcel Service Co · Louisville, KYBuilt 1998 · S/N 28846 N474UPUnited Parcel Service Co · Louisville, KYBuilt 1999 · S/N 28844 N475UPUnited Parcel Service Co · Louisville, KYBuilt 1999 · S/N 28845 N48127United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28968 N507YVBank Of Utah Trustee · Salt Lake City, UTS/N 24607 N567CACascade Spares Inc · Knoxville, TNBuilt 1991 · S/N 24608 N56859United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32818 N57111United Airlines Inc · Chicago, ILBuilt 1994 · S/N 27301 N57852United Airlines Inc · Chicago, ILBuilt 2001 · S/N 32811 N57855United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32814 N57857United Airlines Inc · Chicago, ILBuilt 2004 · S/N 32816

Back to AD 2006-11-05 R2