Registered aircraft · 1,015

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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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:82-09-51-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.

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 N605CSMfjc LLC · Boca Raton, FLBuilt 2009 · S/N 5801

Back to AD 82-09-51 R1