OpenAirDocs.org
AD 2002-19-51 R1

Registered aircraft · 835

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
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:2002-19-51-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:2002-19-51-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.

N976JMBank Of Utah Trustee · Salt Lake City, UTS/N 29190N976NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 33243N977NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31225N978ANMsn 30100 Trust · Wilmington, DEBuilt 2001 · S/N 30100N978NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31226N979ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 29568N979NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31228N980ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33203N980NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31229N981ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29569N981NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31230N982ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31067N982NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 31231N983ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29570N983NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33337N984NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31234N985NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31233N986NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31236N987ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31069N987NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33247N988NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31237N989ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33205N989NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33338N990ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29563N990NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31241N991ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 30920N991NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31242N992ANWilmington Trust Co - Trustee (2008 Msn 31071) · Wilmington, DEBuilt 2009 · S/N 31071N992NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31244N993NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33340N994NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33248N995NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31245N996NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31248N997NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33250N998NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31250
Back to AD 2002-19-51 R1