Registered aircraft · 597

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:97-24-02-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:97-24-02-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:97-24-02-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:97-24-02-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:97-24-02-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:97-24-02-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.

N604ALSabby Aviation LLC · Miami Beach, FLBuilt 1997 · S/N 5360 N604AUBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 5434 N604AVAero Ventures 5 LLC · Torrington, CTBuilt 1999 · S/N 5437 N604BACsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 5476 N604BBMa Aviation LLC · Fargo, NDBuilt 2004 · S/N 5582 N604BCWpc Holdings LLC · Fort Lauderdale, FLBuilt 2000 · S/N 5455 N604BEEwing S Finley III · Plano, TXBuilt 2004 · S/N 5589 N604CHStormy Ashmore LLC · Paradise Valley, AZBuilt 1997 · S/N 5350 N604CRUS Auto Finance Leasing LLC · Wilmington, DEBuilt 2005 · S/N 5615 N604DTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5627 N604EMRegistered aircraftBuilt 2001 · S/N 5492 N604EPTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 5462 N604EXBoomerang Air Inc · Oklahoma City, OKBuilt 1999 · S/N 5420 N604FMBlue Five LLC · Omaha, NEBuilt 2001 · S/N 5488 N604GETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 5393 N604GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 5399 N604GWCfc LLC · Bloomington, INBuilt 1999 · S/N 5424 N604HMHarbert Aviation LLC · Birmingham, ALBuilt 2002 · S/N 5555 N604HSHsl II LLC · Tampa, FLBuilt 1996 · S/N 5311 N604JJRegistered aircraftBuilt 2005 · S/N 5635 N604KEAviation Sales Associates LLC · Costa Mesa, CABuilt 1999 · S/N 5407 N604KJNew Kpc Holdco LLC · Fort Lauderdale, FLBuilt 2002 · S/N 5554 N604LASwallow Acquisitions LLC · Wilmington, DEBuilt 2001 · S/N 5497 N604LBInfinity Aspire Holdings LLC · Miami Beach, FLBuilt 2006 · S/N 5608 N604LLValiair Ltd Co Trustee · Casper, WYBuilt 1996 · S/N 5321 N604MN604m LLC · Scottsdale, AZS/N 5409 N604MBChallenger 601 Holdings LLC · Missoula, MTBuilt 1992 · S/N 5115 N604MHRegistered aircraftBuilt 2003 · S/N 5570 N604MMTc Flight LLC · San Francisco, CABuilt 1998 · S/N 5381 N604MTDodson International Parts Inc · Rantoul, KSBuilt 2000 · S/N 5471 N604NBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 5133 N604PSBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 5447 N604PVStallion Aviation II LLC · Roseland, NJBuilt 2001 · S/N 5478 N604PWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 5638 N604RBLouisiana Aviation LLC · Whitefish, MTBuilt 2002 · S/N 5513 N604RCRockwell Collins Leasing LLC · Cedar Rapids, IABuilt 2006 · S/N 5662 N604RMFireproof Aviation LLC · Southfield, MIBuilt 2000 · S/N 5441 N604SASe Aircraft Leasing LLC · Wilmington, DEBuilt 1999 · S/N 5408 N604SBKhosla Ventures LLC · Menlo Park, CABuilt 2004 · S/N 5569 N604SGGaf Holdings Inc · Visalia, CABuilt 1997 · S/N 5336 N604TBBoeing Company · Berkeley, MOBuilt 2005 · S/N 5614 N604VGNational Products Inc · Seattle, WABuilt 2003 · S/N 5562 N604WARegistered aircraftBuilt 2004 · S/N 5594 N604WBChoice Administrators Insurance Services Inc · Orange, CABuilt 1996 · S/N 5306 N604XTJ Turbines Inc · Wilmington, DEBuilt 1996 · S/N 5307 N604ZTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 5496 N605BCHeights Aviation LLC · Tucson, AZBuilt 2006 · S/N 5705 N605BSStream Enterprises LLC · Marlborough, MABuilt 2013 · S/N 5950 N605CEExpedient Voyages LLC · Westport, CTBuilt 2010 · S/N 5851 N605CLTcp Aviation I LLC · Sacramento, CABuilt 2012 · S/N 5909

Back to AD 97-24-02 R1