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.

N726KPKalinin Partners LLC · Juneau, AKBuilt 2001 · S/N 400 N728LMJacksons Food Stores Inc · Meridian, IDBuilt 2006 · S/N 728 N728MGKnot Crazy Horse LLC · Thonotosassa, FLBuilt 2005 · S/N 607 N72AZBank Of Utah Trustee · Salt Lake City, UTBuilt 2003 · S/N 495 N72DZUS Air Force Special Operations Command/Askm · Hurlburt Field, FLS/N 777 N732LHLaboratory Corporation Of America Holdings · Burlington, NCBuilt 2006 · S/N 732 N732SBAero Shares LLC · Excelsior, MNBuilt 2001 · S/N 410 N735MDUnion Square Investment Co · San Francisco, CABuilt 2006 · S/N 735 N739SBag Management Inc · Ogden, UTBuilt 2007 · S/N 844 N73SJOklahoma Altitude Partners LLC · Enid, OKBuilt 2006 · S/N 773 N73VSJmp Aircraft Services LLC Trustee · Wasilla, AKS/N 817 N740AFUS Air Force Special Operations Command/A5km · Hurlburt Field, FLS/N 740 N742RMiller Mark Trustee · Salt Lake City, UTBuilt 2006 · S/N 742 N743SCMissouri First Aviation Inc · Lebanon, MOBuilt 2007 · S/N 800 N744DATatonduk Outfitters Ltd · Fairbanks, AKBuilt 2006 · S/N 744 N745STN745st LLC · Bayonne, NJBuilt 2006 · S/N 745 N748METvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 820 N749GCLmw Sme LLC · Houston, TXBuilt 2006 · S/N 749 N751FBFb Air LLC · Springfield, MNBuilt 2006 · S/N 751 N755EMSea Star Inc · Wetumpka, ALBuilt 2005 · S/N 661 N755HFN755hf LLC · Haskell, NJBuilt 2006 · S/N 755 N756VMVoigt Consulting Inc · Idaho Falls, IDBuilt 2006 · S/N 756 N758PCBeam 33 Inc · Billings, MTBuilt 2006 · S/N 698 N758QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 2006 · S/N 758 N759PBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2006 · S/N 759 N766DLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2004 · S/N 601 N769EBSprintbach Corp · Caldwell, IDBuilt 2006 · S/N 769 N770FLTailwinds Aviation LLC · Wilmington, DEBuilt 2003 · S/N 501 N770PWJ Guy LLC · Boerne, TXBuilt 2006 · S/N 757 N771WBAir Bus LLC · Dickinson, NDS/N 240 N774DKOrr Franklin M Jr Trustee · Stanford, CABuilt 1996 · S/N 167 N774GWMclovin Air LLC · Ashburn, VABuilt 2006 · S/N 774 N775CCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2007 · S/N 792 N776JTBoutique Air Inc · Dallas, TXBuilt 2004 · S/N 563 N777CQArctic One LLC · Fairbanks, AKS/N 754 N779PCUS Air Force Special Operations Command/A5km · Hurlburt Field, FLS/N 779 N77ZAAngel Lou Aviation LLC · Gilford, NHBuilt 1999 · S/N 300 N77ZEPmc Distribution Inc · Keswick, VABuilt 2000 · S/N 340 N781DLRice Flying LLC · Poplar Bluff, MOBuilt 2000 · S/N 334 N782JCJsc Air LLC · Des Moines, IABuilt 2006 · S/N 731 N783PCDapcon Consulting Inc · Chicago, ILBuilt 2006 · S/N 783 N786WMHinterland Holdings LLC · Anchorage, AKBuilt 2007 · S/N 786 N78PGLance Toland Ltd · Wilmington, DEBuilt 2000 · S/N 370 N791MBPj Aviation Holding LLC Trustee · Eden Prairie, MNBuilt 2007 · S/N 791 N796PCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 796 N797GMSwiss Miss LLC · Woodside, CABuilt 2006 · S/N 747 N798RGAlaska Skypower LLC · Fairbanks, AKBuilt 2007 · S/N 798 N798WCLonely Butte Management LLC · St George, UTBuilt 2005 · S/N 613 N79CSFord Gt Holdings LLC · Fort Dodge, IABuilt 1995 · S/N 125 N7YRBoutique Air Inc · Dallas, TXS/N 532

Back to AD 2008-07-11 R1