OpenAirDocs.org
AD 99-23-22 R2

Registered aircraft · 1,336

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:99-23-22-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:99-23-22-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.

N982TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53632N983ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29570N983NNAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 33337N983TWJetran LLC · Horseshoe Bay, TXBuilt 1999 · S/N 53633N984NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31234N985NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31233N986AKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1989 · S/N 49412N986NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31236N987AK987 Investments LLC · Spring, TXS/N 49404N987ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 31069N987CFPeekey Lumbus LLC · Vista, CABuilt 2007 · S/N 351N987GCGenesis Custom Jetliners LLC · New York, NYBuilt 1991 · S/N 53040N987NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33247N988AKExecutive Aircraft Sales LLC · Charlotte, NCBuilt 1987 · S/N 22N988NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31237N988TNext Century Aviation Oregon LLC · Sausalito, CABuilt 1988 · S/N 65N989ANWilmington Trust Co Trustee · Wilmington, DEBuilt 2009 · S/N 33205N989NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 33338N98ACPf Travel LLC · Encinitas, CABuilt 2002 · S/N 329N990ANAmerican Airlines Inc · Fort Worth, TXBuilt 2009 · S/N 29563N990LTLife Time Fitness Inc · Chanhassen, MNBuilt 1988 · S/N 60N990NNAmerican Airlines Inc · Fort Worth, TXBuilt 2016 · S/N 31241N990WRBam Aviation LLC · Jupiter, FLS/N 126N991ANAmerican 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 31071N992NANational Aeronautics And Space Administration · Houston, TXBuilt 1980 · S/N 309N992NNAmerican 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 31250N9CUJani King International Inc · Addison, TXBuilt 1987 · S/N 19N9TEAlliance Aviation Group LLC · Wilmington, DEBuilt 1991 · S/N 204
Back to AD 99-23-22 R2