Registered aircraft · 288

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:98-16-17-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:98-16-17-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:98-16-17-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:98-16-17-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:98-16-17-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:98-16-17-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.

N232CFValiair Limited Co Trustee · Casper, WYBuilt 2001 · S/N 750-0161 N237MCWnr1 Holdings Aviation LLC · Mount Juliet, TNBuilt 1997 · S/N 750-0014 N248HAH Citation X LLC · Flushing, NYBuilt 2008 · S/N 750-0285 N249ALTen One LLC · Carmel, INBuilt 2005 · S/N 750-0249 N255FPUfp Industries Inc · Grand Rapids, MIBuilt 2017 · S/N 750-0527 N255SHAir Rights Aviation LLC · Phoenix, AZBuilt 2004 · S/N 750-0235 N265AVBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 750-0256 N26BHHabib Aviation LLC · West Palm Beach, FLBuilt 2000 · S/N 750-0136 N26BTSkmdlm LLC · Dallas, TXBuilt 1998 · S/N 750-0039 N26MJRoss Aviation Inc · Cortland, OHBuilt 2001 · S/N 750-0139 N299CXContrails II Inc · Kerrville, TXBuilt 2009 · S/N 750-0299 N301HRCitation X Parts LLC · Liberty, NCBuilt 1998 · S/N 750-0062 N305DJN305dj LLC · Fort Lauderdale, FLBuilt 1997 · S/N 750-0013 N307FFN390sf LLC · Chandler, AZBuilt 1998 · S/N 750-0059 N347RLLevi Ray & Shoup Inc · Springfield, ILBuilt 2007 · S/N 750-0276 N347WSCitation X17 Ventures LLC · Gastonia, NCS/N 750-0017 N348CFBoss 8 LLC · Fort Worth, TXBuilt 2001 · S/N 750-0160 N34HHHawker Leasing LLC · Orlando, FLBuilt 2012 · S/N 750-0307 N354WCKba Group LLC · Tarzana, CABuilt 2002 · S/N 750-0191 N369BIal Corp · Lewes, DEBuilt 1997 · S/N 750-0030 N387SLIndigo Rio Management LLC · Corona, CABuilt 2017 · S/N 750-0524 N399LFUp Up And Away LLC · Broomfield, COBuilt 2003 · S/N 750-0213 N399WAurora Aircraft LLC · Waterford, MIBuilt 2001 · S/N 750-0171 N3BGoing Up LLC · Stockton, CABuilt 2015 · S/N 750-0521 N405BSRadio Flyer LLC · Granbury, TXBuilt 1998 · S/N 7500041 N411NKAir Base LLC · Jupiter, FLBuilt 2012 · S/N 750-0311 N414FJFliteaccess LLC · Louisville, KYBuilt 2003 · S/N 750-0221 N420KM420 Aviation LLC · Seattle, WABuilt 2004 · S/N 7500234 N420ZZBlackbay Investments LLC · Sioux Falls, SDBuilt 2003 · S/N 750-0211 N425KNDime Piece LLC · Morristown, TNBuilt 2001 · S/N 7500181 N427TFG3 Aviation LLC · Cranston, RIBuilt 2018 · S/N 750-0528 N444BCBerry Gp Inc · Corpus Christi, TXBuilt 1997 · S/N 750-0025 N448CXRosado Aviation Inc · Moosic, PABuilt 2006 · S/N 750-0252 N44PRTown And Country Food Markets Inc · Wichita, KSBuilt 2004 · S/N 750-0214 N45DRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 750-0197 N474MEHome Cloud Aviation LLC · West Palm Beach, FLBuilt 2001 · S/N 750-0155 N478PMAir Reese LLC · Cypress Mill, TXS/N 750-0518 N480WTWhiskey Tango Foxtrot Motorsports LLC · Scottsdale, AZBuilt 1996 · S/N 750-0004 N507TSTextron Inc · Providence, RIBuilt 2014 · S/N 750-0507 N509CXTextron Inc · Providence, RIBuilt 2014 · S/N 750-0509 N512HAHa X288 LLC · Wilmington, DEBuilt 2008 · S/N 750-0288 N513JBCitation X Parts LLC · Liberty, NCBuilt 2000 · S/N 750-0129 N514XNewport Sea Pines LLC · Austin, TXBuilt 1998 · S/N 750-0065 N517CFCitation X Parts LLC · Liberty, NCBuilt 1998 · S/N 750-0049 N51GBCitation X Leasing LLC · Liberty, NCBuilt 2001 · S/N 750-0142 N520CXN520cx Aviation LLC · Taylor, LABuilt 2015 · S/N 750-0520 N527NPNoble Air LLC · Palm Beach Gardens, FLBuilt 2004 · S/N 750-0231 N537WCWh Holdings 2014 LLC · West Lake Hills, TXBuilt 2014 · S/N 750-0511 N541CXCgw Southeast Management X LLC · Newark, DEBuilt 1997 · S/N 750-0036 N546MDDavis Leasing LLC · Vero Beach, FLBuilt 2003 · S/N 750-0215

Back to AD 98-16-17 R1