Registered aircraft · 1,286

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:2002-22-13') 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-22-13') 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:2002-22-13')
    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-22-13')
  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:2002-22-13')
  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-22-13')
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.

N322APSkylark Partners Management LLC · Austin, TXBuilt 2008 · S/N 5754 N322LVBig Rapids Products Aviation LLC · Big Rapids, MIBuilt 2004 · S/N 5587 N3250NGarrote Aviation LLC · Jackson, WYBuilt 2010 · S/N 5849 N327TWEmily Aviation LLC · Madison, NJBuilt 1999 · S/N 5421 N329MDUjm I LLC · Naples, FLS/N 5098 N329TLBlue Spruce Seven LLC · Dallas, TXBuilt 2007 · S/N 5714 N32BTDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 5474 N330LDSs Leasing LLC · Rochester, MNBuilt 2009 · S/N 5816 N330RSmytheair LLC · Newburgh, INBuilt 2004 · S/N RK-386 N332AVSancon Leasing LLC · Nashville, TNBuilt 2001 · S/N RK-332 N335MSWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7247 N33BLLot Equipment LLC · Baton Rouge, LAS/N RK-393 N340AK2fast Aviation LLC · Wilmington, DEBuilt 1999 · S/N 5405 N3438Imeca Jet LLC · Miami Gardens, FLBuilt 2008 · S/N RK-569 N346HGReal Logistics LLC · Greenville, SCBuilt 2002 · S/N RK-346 N349FJFlying Aceholes LLC · Amarillo, TXS/N RK-349 N359VValmont Industries Inc · Omaha, NEBuilt 1997 · S/N 5349 N360Lga Trading LLC · Sheridan, WYBuilt 1990 · S/N 5068 N360RLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1991 · S/N 5089 N365KMMansfield Aviation LLC · Gainesville, GABuilt 2005 · S/N 5603 N365NNMozart Air LLC · Dover, DES/N 5901 N365SLN702sj LLC · Scottsdale, AZBuilt 2001 · S/N 7489 N366LPAlliance Air Parts Acquisitions Corp · Oklahoma City, OKNon-citizen corporation, flight hours not reportedS/N 5091 N367PLSdbw Aero Holdings LLC · Columbus, OHBuilt 1996 · S/N 5303 N368FJValiair Lc Trustee · Casper, WYBuilt 1989 · S/N 5049 N36VVRedgate Partners LLC · Whittier, CABuilt 1997 · S/N 5338 N37178Bank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 7178 N3726Canyons Aviation Group LLC · Orlando, FLBuilt 1997 · S/N 5351 N372GKemper Corporate Services Inc · Chicago, ILBuilt 2011 · S/N 5867 N372MZZubi5372 LLC · Wilmington, DEBuilt 1998 · S/N 5372 N375DTAhj Hawk Aviation LLC · Bonita Springs, FLS/N RK-372 N375MZZubi5375 LLC · Wilmington, DEBuilt 1998 · S/N 5375 N379RKAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2004 · S/N RK379 N384CRBank Of Utah Trustee · Salt Lake City, UTS/N 7384 N387LSBeech Transportation Inc · Eden Prairie, MNS/N RK-351 N38CGCorning Inc · Corning, NYBuilt 2008 · S/N 8088 N38TPBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N RK-333 N390SB400xp Shares LLC · Liberal, KSBuilt 2004 · S/N RK-390 N396SAMard Aviation LLC · Johnstown, PABuilt 2003 · S/N 7839 N397MGAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1999 · S/N RK-259 N39REAirush Inc · New Braunfels, TXBuilt 2010 · S/N 5850 N400ALN400al Leasing LLC · Wichita, KSBuilt 1997 · S/N RK-172 N400AXN400ax Leasing LLC · Wichita, KSBuilt 1997 · S/N RK-171 N400BHBbh Partnership LLC · Topeka, KSBuilt 2005 · S/N RK-407 N400CNTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N RK-532 N400DCRk-250 Leasing LLC · Wichita, KSBuilt 1999 · S/N RK-250 N400DGN400dg Leasing LLC · Wichita, KSBuilt 1997 · S/N RK-150 N400DHJoe Gibbs Racing LLC · Huntersville, NCBuilt 1998 · S/N 5371 N400DLN400dl Leasing LLC · Wichita, KSS/N RK-213 N400DXN400dx Leasing LLC · Wichita, KSBuilt 2000 · S/N RK-287

Back to AD 2002-22-13