Registered aircraft · 4,274

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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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:2009-21-10-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.

N396NSAviation Sales Associates LLC · Costa Mesa, CABuilt 1999 · S/N 1395 N396UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40364 N39726United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28796 N39728United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28944 N397ACTvpx Trust Co LLC Trustee · North Salt Lake, UTS/N 2982 N397AZCargo Aircraft Management Inc · Wilmington, OHBuilt 1988 · S/N 24035 N397DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30537 N397DNDelta Air Lines Inc · Atlanta, GABuilt 2019 · S/N 9176 N397JJAvion LLC · Birmingham, ALBuilt 1998 · S/N 1354 N397UPUnited Parcel Service Co · Louisville, KYBuilt 2010 · S/N 40363 N398AVAircol 6 Statutory Trust · Wilmington, DEBuilt 2009 · S/N 3988 N398DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30774 N398DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 9360 N399DADelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30379 N399MTBank Of Utah Trustee · Salt Lake City, UTS/N 29741 N39AVBlackbird Jet LLC · Boca Raton, FLBuilt 1989 · S/N 1113 N4005XAmerican Airlines Inc · Fort Worth, TXBuilt 2013 · S/N 5753 N400AJMilberg Falcon Express LLC · Knoxville, TNBuilt 1990 · S/N 1129 N400FJPtj Associates LLC · South Pasadena, CABuilt 2002 · S/N 1494 N400JZJrb Pelican Point Investments LLC · Pompano Beach, FLBuilt 1994 · S/N 1255 N400SFGlobal Aero Aviation Inc · Houston, TXBuilt 1987 · S/N 1026 N400ZUEastern Stearman Inc Trustee · Leesburg, VABuilt 1986 · S/N 1009 N401AVAircol 8 · Wilmington, DEBuilt 2009 · S/N 4001 N401JSMm Fleet Holdings LLC · Farmers Branch, TXBuilt 2000 · S/N 1423 N401UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 435 N402ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 41189 N402UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 439 N4032TAmerican Airlines Inc · Fort Worth, TXBuilt 2015 · S/N 6644 N403ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41730 N403JSPistola Alta LLC · Miami, FLBuilt 2000 · S/N 1433 N403SBSmb G-IV X LLC · Longwood, FLS/N 1417 N403TB403tb LLC · Dover, DEBuilt 1992 · S/N 1191 N403YKNorthern Air Cargo LLC · Anchorage, AKBuilt 1992 · S/N 25842 N404KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 34283 N404UAUnited Airlines Inc · Chicago, ILBuilt 1993 · S/N 450 N405CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1991 · S/N 25407 N405KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36132 N405YKNas Aircraft Leasing Company LLC · Anchorage, AKBuilt 1991 · S/N 25267 N406CKKalitta Charters II LLC · Ypsilanti, MIBuilt 1997 · S/N 28752 N406KZWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N 36133 N406UAUnited Airlines Inc · Chicago, ILBuilt 1994 · S/N 454 N407ASAlaska Airlines Inc · Seatac, WABuilt 2012 · S/N 41731 N408ASAlaska Airlines Inc · Seattle, WABuilt 2012 · S/N 41732 N408JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 1402 N409ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41733 N409YKAircraft 25859 LLC · Lake Mary, FLBuilt 1993 · S/N 25859 N40VCFuerza Regida Corp · San Bernardino, CABuilt 1997 · S/N 1316 N410ACBank Of Utah Trustee · Salt Lake City, UTS/N 3045 N410GXWilmington Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 01199 N41135United Airlines Inc · Chicago, ILBuilt 1999 · S/N 29284

Back to AD 2009-21-10 R1