Skip to content

AD 2009-13-06 R1

Registered aircraft · 2,131

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.

N27674Georges Aviation Services Inc · Honolulu, HIBuilt 1978 · S/N 31-7852100 N27682D And R Hobbs Properties LLC · Rogers, ARBuilt 1978 · S/N 31-7852105 N27693Sanborn Map Co Inc · Colorado Springs, COBuilt 1978 · S/N 31-7812091 N27699Curnutt Daniel E · Tanner, ALBuilt 1978 · S/N 31-7812094 N27701Secure Aviation Inc · Tequesta, FLBuilt 1978 · S/N 31-7812096 N27712Juliet Lima Marketing Inc · West Palm Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 31-7812102 N27755Air Arctic Inc · Fairbanks, AKBuilt 1978 · S/N 31-7852148 N27800International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 31-7852156 N27835Aerowerks LLC · Louisville, KYBuilt 1978 · S/N 31-7912016 N27888Tep LLC · Ormond Beach, FLBuilt 1978 · S/N 31-7952025 N27917Warbelows Air Ventures Inc · Fairbanks, AKBuilt 1978 · S/N 31-7952007 N27989Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1979 · S/N 31-7952077 N27990Aztec Worldwide Airlines Inc · Wilmington, DEBuilt 1979 · S/N 31-7952079 N279CTShelton Paul K · Flushing, NYBuilt 1973 · S/N 31P-7300172 N27BFJab Air LLC · Ponte Vedra Beach, FLBuilt 1981 · S/N 31T-8104038 N27CYSale Reported · Hastings, FLSale reportedBuilt 1976 · S/N 27-7654118 N27FMGogoplex LLC · Wilmington, DEBuilt 1976 · S/N 27-7654087 N27HPTrinair Aviation LLC · Hampshire, ILBuilt 1962 · S/N 27-2034 N282PCW O Powers Management Inc · Florence, SCBuilt 1981 · S/N 31T-8166006 N283GTKinz Air LLC · Winter Springs, FLBuilt 1979 · S/N 31-7952139 N284HBAviatiek LLC · Hudsonville, MIBuilt 1979 · S/N 31-7912099 N284SBWestwind Inc · Liberal, KSS/N 31T-7820074 N285MEN285me Holding LLC · Palm City, FLS/N 31-7405410 N286DDKhag Aviation Inc · Woodbridge, NJS/N 27-7854019 N28BGKapowsin Air Sports Ltd · Shelton, WABuilt 1976 · S/N 31T-7720005 N28DFGlobal Avionics LLC · Downey, CAS/N 31-7812121 N28DVHood Geoffrey A · Gladstone, MOS/N 31-7912063 N28KEGrant Aviation Inc · Anchorage, AKS/N 31-8152049 N28WRN28wr LLC · Simpsonville, SCBuilt 1971 · S/N 27-4626 N290MSurging Skyward Inc · Newtown, PAS/N 27-7554111 N290VGAlmy David W · Riverside, CAS/N 23-5 N291VPSeacrest Enterprises LLC · Asheville, NCS/N 27-8154025 N294ZPCumulus Aviation Inc Trustee · Wilmington, DEBuilt 1980 · S/N 31T-8020063 N295SBChagres Aero LLC · Albuquerque, NMBuilt 1979 · S/N 27-7954091 N296CHTgl Partners LLC · Plant City, FLBuilt 1978 · S/N 31-7812062 N297JGInternational Air Services Inc Trustee · Carson City, NVBuilt 1979 · S/N 317952043 N299RMGulf Atlantic Airways Inc · Gainesville, FLBuilt 1979 · S/N 27-8054024 N29AHRiseaero LLC · Florence, SCS/N 27-398 N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147 N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342 N2PNFugro USA Land Inc · Rapid City, SDBuilt 1977 · S/N 31-7752141 N2QWPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754126 N2RPFasken Frank Andrew · Paris, TXS/N 27-7754160 N2XRInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 318152014 N300SRLevenson Louis · Atlanta, GABuilt 1981 · S/N 31T-8104022 N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294 N300WPPcp Aviation LLC · Miramar Beach, FLBuilt 1978 · S/N 31T-7904006 N3019PNelson Matthew J · Frewsburg, NYBuilt 1957 · S/N 23-928 N301SWFly Rite Aviation LLC · Fort Myers, FLS/N 27-195 N3024PPrentice Robert D · Ripon, WIBuilt 1957 · S/N 23-935

Back to AD 2009-13-06 R1