Registered aircraft · 545

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:2008-07-11-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:2008-07-11-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:2008-07-11-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:2008-07-11-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:2008-07-11-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:2008-07-11-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.

N584STNortheast Montana Stat Air Ambulance Cooperative · Glasgow, MTBuilt 2003 · S/N 509 N588KCTejas Global Trust LLC · San Antonio, TXBuilt 2004 · S/N 588 N589QDQuest Diagnostics Clincal Laboratories Inc · Reading, PAS/N 589 N5904ALaboratory Corporation Of America Holdings · Burlington, NCBuilt 2004 · S/N 583 N590ERBlue Ocean Aerospace LLC · Fort Collins, COBuilt 2008 · S/N 886 N590TWPriority Air Charter LLC · Kidron, OHBuilt 1998 · S/N 235 N591SSCommercial Air LLC · Reno, NVBuilt 2004 · S/N 591 N593PCUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 593 N594WAFifth Direct Air LLC · Polson, MTBuilt 2004 · S/N 594 N598MMHang Time LLC · Charlotte, NCBuilt 2004 · S/N 598 N599PBEdgewater LLC · North Charleston, SCBuilt 2004 · S/N 599 N5DMGuardian Flight LLC · Lewisville, TXBuilt 2000 · S/N 355 N600WYAereo LLC · Casper, WYBuilt 2003 · S/N 526 N601BGManagement Systems Corp · Grand Forks, NDBuilt 1997 · S/N 181 N605PCLogan Health Medical Center · Kalispell, MTBuilt 2004 · S/N 605 N607AHBurnette Air LLC · Norfolk, VABuilt 2007 · S/N 825 N608SMLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2006 · S/N 734 N60WPTrinity River Lumber Co · Weaverville, CABuilt 1996 · S/N 144 N610GHHtc Aviation LLC · Lititz, PABuilt 2003 · S/N 103 N612CRDiamond Resorts West LLC · Edwards, COBuilt 2001 · S/N 364 N612JSmith Frank Ford Jr · Wilmington, DEBuilt 2003 · S/N 494 N612KCHillcrest Aircraft Co Inc · Lewiston, IDBuilt 1997 · S/N 173 N616EAEmpireair LLC · Spokane Valley, WABuilt 2005 · S/N 616 N618JCMclean Aviation Services Inc · Napa, CABuilt 2005 · S/N 618 N620WALaboratory Corporation Of America Holdings · Burlington, NCBuilt 2005 · S/N 620 N623ACViolich Farms Inc · Kentfield, CAS/N 722 N623BALmco · Vandenberg Afb, CABuilt 2005 · S/N 623 N628MCAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 516 N629DFRojo Express LLC · Holland, MIBuilt 2004 · S/N 590 N62GAFlagstaff Medical Center Inc · Flagstaff, AZBuilt 1999 · S/N 259 N631BLBancfirst · Oklahoma City, OKBuilt 2005 · S/N 631 N631DBApostle Air LLC · Colorado Springs, COBuilt 2008 · S/N 885 N636QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2005 · S/N 636 N637PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 627 N637PHCapital Holdings 137 LLC · Tavernier, FLBuilt 2005 · S/N 637 N638AVPilatus 638 LLC · Dover, DEBuilt 2005 · S/N 638 N640MYManatee Jet Club LLC · Bradenton, FLBuilt 2005 · S/N 640 N641ATHinterland Holdings LLC · Anchorage, AKS/N 767 N642PCAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 642 N642SFCoastal Recovery LLC · Fort Lauderdale, FLBuilt 1998 · S/N 218 N643PCRegistered aircraftBuilt 2005 · S/N 643 N644SDSierra Delta LLC · Lititz, PABuilt 2005 · S/N 644 N645PCValiair Limited Co Trustee · Casper, WYBuilt 2005 · S/N 645 N646VLRegistration Pending · Emerald Hills, CARegistration pendingBuilt 2001 · S/N 372 N649PBoutique Air Inc · Dallas, TXBuilt 2005 · S/N 649 N650BGP & M Aero LLC · Belle Chasse, LABuilt 2005 · S/N 654 N650LLLikover Larry L · Houston, TXBuilt 2002 · S/N 449 N650MCN650mc LLC · Bountiful, UTBuilt 2005 · S/N 650 N651PBJm Aviation LLC · Ocala, FLBuilt 2005 · S/N 651 N652CRCritical Craft Technologies LLC · Charlotte Hall, MDS/N 652

Back to AD 2008-07-11 R1