Registered aircraft · 1,287

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.

N685BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2002 · S/N 7712 N686BRBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 7715 N686SCKa Corp · Missoula, MTBuilt 1998 · S/N RK-211 N689MVBypass Tsa LLC · Chesterfield, MOBuilt 2005 · S/N 5631 N689SCRegistered aircraftBuilt 2007 · S/N 5716 N68ABRockwell Automation Inc · Milwaukee, WIBuilt 2024 · S/N 6202 N68GSFriesen Group Inc · Redding, CAS/N RK-391 N691CCWilmington Trust Co Trustee · Wilmington, DEBuilt 1993 · S/N 5126 N693BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7761 N696HSMocha LLC · Tucson, AZBuilt 2009 · S/N 5819 N698GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 6120 N698RSNo Bull Air LLC · Chandler, AZBuilt 2000 · S/N 5460 N699BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7801 N699STOrange Equipment LLC · Miami Beach, FLBuilt 2006 · S/N 5743 N69DTAir Dan LLC · Houston, TXBuilt 2000 · S/N 5448 N6EETvpx Aircraft Solutions Inc Owner Trustee · North Salt Lake, UTS/N 5703 N700JDWest Cherry Sales LLC · Wilmington, DEBuilt 2010 · S/N 5860 N700JPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 5355 N701BRCorporate Flight Management Inc DBA · Smyrna, TNBuilt 2000 · S/N 7448 N702LVImocas LLC · Las Vegas, NVBuilt 2011 · S/N 5875 N703SAC&S Crj200-1 LLC · Beverly, MABuilt 2003 · S/N 7730 N704RRWkair 1 LLC · Boerne, TXBuilt 2003 · S/N 5558 N705RRRr604 LLC · Charlotte, NCBuilt 1996 · S/N 5327 N705VSTi Aviation LLC · Wilmington, DES/N 5392 N706RMUt Air LLC · Miami, FLBuilt 1997 · S/N RK-161 N707KSHr Top Gun LLC · Petaluma, CABuilt 2004 · S/N 5581 N709BA5811 LLC · Meridian, IDBuilt 2009 · S/N 5811 N709BRSkywest Airlines Inc · St George, UTBuilt 2003 · S/N 7850 N709ELRcm Air LLC · Davie, FLBuilt 1992 · S/N RK-52 N70XTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1990 · S/N 5073 N710ANGlobal Challenger LLC · Soldotna, AKBuilt 1994 · S/N 5150 N710AVBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeS/N 7165 N710RAA & E Hawker Lp · Santa Ana, CABuilt 2007 · S/N RK-543 N711AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 6154 N711WSTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 1996 · S/N 7140 N712AGBanc Of California · Chicago, ILBuilt 2012 · S/N 5927 N712PRAviation Resource Group Inc · Fort Lauderdale, FLBuilt 1996 · S/N 5313 N713JMJp Ashley LLC · Lewes, DEBuilt 2004 · S/N 5586 N715AVLead And Steel 3 LLC · Fountain Valley, CABuilt 1996 · S/N 7158 N715JFFabair LLC · Milwaukee, WIBuilt 2008 · S/N 8095 N7164Crj Capital Corp · Miami, FLBuilt 1997 · S/N 7164 N716BBPinnacle Aviation Group LLC · Wilmington, DES/N 5477 N716JRHugo Enterprises LLC · Omaha, NEBuilt 2010 · S/N 5847 N716TMTitan Strong LLC · Staten Island, NYBuilt 1997 · S/N 5344 N717BNBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 5960 N719AVLead And Steel LLC · Fountain Valley, CABuilt 1996 · S/N 7159 N719ELEdra Lauren Leasing Corp · Cincinnati, OHS/N RK-488 N71AVWells Fargo Trust Co Na Trustee · Salt Lake City, UTS/N 7124 N71KRLost Highway Touring Inc · Clarkston, MIBuilt 1995 · S/N 5191 N71TAPlane Holdings LLC · Shawnee, KSBuilt 2000 · S/N RK-272

Back to AD 2002-22-13