Skip to content

AD 2009-13-06 R1

Registered aircraft · 2,130

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-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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:2009-13-06-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.

N54775Hankins Shannon G · Tulsa, OKBuilt 1975 · S/N 27-7554082 N54796Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554097 N54808Wsk Inc · Wolfeboro, NHBuilt 1975 · S/N 277554106 N54809Mgc LLC · Brandon, FLBuilt 1975 · S/N 27-7554108 N54810Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554109 N54811Simms Linda Ann Murray Trustee · Westminster, MDBuilt 1975 · S/N 27-7554110 N54854Registration Pending · Saint Augustine, FLRegistration pendingBuilt 1975 · S/N 27-7554154 N54857Mach Tuck LLC · Daytona Beach, FLBuilt 1975 · S/N 27-7554157 N54858Advanced Aviation Group LLC · Frederick, MDBuilt 1975 · S/N 27-7554158 N54861Fly Car Aviation LLC · North Fort Myers, FLBuilt 1975 · S/N 27-7554159 N54862J&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1975 · S/N 27-7554161 N54870Senter Carl V · Coeymans, NYBuilt 1975 · S/N 27-7554165 N5494YSchildberg Gregory M · Casey, IABuilt 1964 · S/N 27-2587 N5495YBerman Samuel I · Minneapolis, MNBuilt 1964 · S/N 27-2588 N549JBBlue Bird Aviation LLC · Ocean City, MDBuilt 1980 · S/N 31-8052108 N54AWWilson Cecil P · Lithonia, GABuilt 1974 · S/N 27-7405392 N54CLAir Transport Resources · Naperville, ILBuilt 1970 · S/N 31-652 N54MVNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1976 · S/N 27-7654043 N54STMac Air Aviation LLC · Xenia, OHBuilt 1974 · S/N 27-7405358 N54WAWright Air Service Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652067 N5502YCreative Strategies Inc · Grayson, KYBuilt 1964 · S/N 27-2596 N5533YAce Tomato Co LLC · Daytona Beach, FLBuilt 1964 · S/N 27-2631 N5545YKolarek Frank · West Nyack, NYFirst renewal noticeBuilt 1964 · S/N 27-2644 N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157 N555DCAmoroso Ricardo C · Powder Springs, GABuilt 1959 · S/N 23-1780 N555FRWallace Jeffrey S · Bonita Springs, FLS/N 31T-8004010 N555FSJacko Josh E · Anchorage, AKBuilt 1978 · S/N 31-7952046 N555GTRegistered aircraftBuilt 1979 · S/N 31-7952148 N555JGLeia Air LLC · Wilmington, DEBuilt 1979 · S/N 31-8012018 N555MFCloud 555 Inc · Wilmington, DEBuilt 1980 · S/N 31-8012068 N555PRHarlan Thomas D · Fresno, CABuilt 1969 · S/N 27-4248 N5571VColeman Douglas E · Tallahassee, FLBuilt 1959 · S/N 23-1784 N5579YHepner Glenn L · New Port Richey, FLBuilt 1964 · S/N 27-2684 N5588YBrennan Thomas F · Titusville, PAS/N 27-2695 N559JTOrian Dillon R · Malibu, CABuilt 1960 · S/N 27-286 N55JELakes Area Aviation LLC · Little Falls, MNS/N 23-772 N55MTKramp William J · Post Falls, IDBuilt 1966 · S/N 27-3575 N55PBHorizon Dreams LLC · Homer, GABuilt 1962 · S/N 27-2184 N55RPneuma Aviation LLC · New Orleans, LABuilt 1976 · S/N 31T-7620055 N560DBAnderson Aerial Spraying Svc Inc · Canby, MNBuilt 1964 · S/N 27-2722 N5622YStephan Jesse A · Richmond, TXBuilt 1964 · S/N 27-2732 N5629YTart John W · Fayetteville, NCBuilt 1964 · S/N 27-2741 N5644YGantt William M · Port Orange, FLBuilt 1965 · S/N 27-2758 N5649YPotenza Austin · Phoenix, AZBuilt 1964 · S/N 27-2764 N565BTGsg Aviation LLC · Fort Lauderdale, FLBuilt 1980 · S/N 31-8052118 N5671YShore Gerry · Inez, TXBuilt 1965 · S/N 27-2785 N5683YCaribbean Flyer LLC · Kinshill, VIBuilt 1965 · S/N 27-2799 N5687YBrouse Dan T · Magnolia, TXBuilt 1965 · S/N 27-2805 N5688YYates Mary A · Haysi, VABuilt 1965 · S/N 27-2806 N5693YAlligator Air Transport LLC · Fort Lauderdale, FLS/N 27-2813

Back to AD 2009-13-06 R1