Skip to content

AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2') 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:2009-10-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2')
  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:2009-10-09-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2')
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.

N704KDSmith Kenneth E Jr · Collinsville, OKBuilt 1976 · S/N 15078664 N704KHCampbell Bruce A · Henderson, NVBuilt 1976 · S/N 15078668 N704KPMassari John C · Wantage, NJBuilt 1976 · S/N 15078674 N704KQJones Gary L · Athens, GABuilt 1976 · S/N 15078675 N704KREagle Aeroplane LLC · Delano, TNBuilt 1976 · S/N 15078676 N704KSFlying Ace LLC · Lakeville, MNS/N 15078677 N704KUHoelscher Mark A · Richmond, INS/N 15078679 N704KVArellano Eric · Harlingen, TXBuilt 1976 · S/N 15078680 N704KXBain Joshua L · Watauga, TXBuilt 1976 · S/N 15078682 N704LASoutheastern Oklahoma State University · Durant, OKBuilt 1976 · S/N 15078685 N704LCEdwards Pacific Aviation Corp · Dover, DEBuilt 1976 · S/N 15078687 N704LFSable Douglas B · Petersburg, VABuilt 1976 · S/N 15078690 N704LGMunger Christopher M · Watertown, MABuilt 1976 · S/N 15078691 N704LJLepp Jason E · Butterfield, MNBuilt 1976 · S/N 15078693 N704LKGreen Daryl Keith · Grove City, OHBuilt 1976 · S/N 15078694 N704LPRother Michael V · Granbury, TXBuilt 1976 · S/N 15078698 N704LRTcm Flying Club Inc · Mobile, ALBuilt 1976 · S/N 15078700 N704LVBrock George W · Union, MOBuilt 1976 · S/N 15078704 N704MGStephens Brian A · Bruceville, INS/N 15078715 N704MHOrmond Aircaft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N 15078716 N704MKPerez Sigfredo A · Fort Buchanan, PRS/N 15078718 N704MQGriffin Shawn · Locust Grove, GAS/N 15078723 N704MTAirways Aviation Services LLC · Miami, FLBuilt 1976 · S/N 15078726 N704MUJones K L III · Jasper, ALBuilt 1976 · S/N 15078727 N704NCShaw Paul W · Pecos, TXS/N 15078734 N704NKRebel Aviation Inc · Liberty, MOBuilt 1976 · S/N 15078741 N704NLJ&J Aeronautics LLC · Houston, TXBuilt 1976 · S/N 15078742 N704NQAllard Yoshimi · Carmel, CABuilt 1976 · S/N 15078746 N704NWVan Warmerdam Les C · Nampa, IDBuilt 1976 · S/N 15078752 N704PCJeff Air Pilot Services LLC · Shelbyville, INBuilt 1976 · S/N 15078757 N704PDSale Reported · Peachtree City, GASale reportedBuilt 1976 · S/N 15078758 N704PFBlackburn Andrew J · Rome, GABuilt 1976 · S/N 15078760 N704PHDeters Isaac John · Preston, MNBuilt 1976 · S/N 15078762 N704PKArg Management - Clemson Blvd LLC · Sandy Springs, SCS/N 15078764 N704PMMayes Martin D · Brooklyn, MIBuilt 1976 · S/N 15078766 N704PSSharp Charles B · Fulton, KYS/N 15078771 N704PVTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1976 · S/N 15078774 N704PWGwinn Anthony N · Grand Haven, MIBuilt 1976 · S/N 15078775 N704QAWashington State Community College · Spokane, WABuilt 1976 · S/N 15078779 N704QBDu Christopher T · Nolensville, TNBuilt 1976 · S/N 15078780 N704QFBevan Michael A · Seabeck, WABuilt 1977 · S/N 15078784 N704QHPfisters Flying Wahaine LLC · Waialua, HIBuilt 1976 · S/N 15078786 N704QLHall Jeffery · Farmington, MNBuilt 1976 · S/N 15078789 N704QMWells Greg DBA · Woodbury, MNBuilt 1976 · S/N 15078790 N704QPDornink Steven R · Freeport, ILBuilt 1976 · S/N 15078792 N704QSSperling Deborah E · Lincoln, MABuilt 1976 · S/N 15078795 N704QYCarney Robby D · Howe, TXS/N 15078801 N704RCHuffman Jacob M III · Burleson, TXBuilt 1976 · S/N 15078805 N704RFTaylor Casey J · Lindsay, OKBuilt 1976 · S/N 15078808 N704RGStankovits Zachary P · Henderson, NVBuilt 1976 · S/N 15078809

Back to AD 2009-10-09 R2