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.

N9319UJohnson Douglas G · Mason City, IABuilt 1976 · S/N 15078269 N93214Sundance Air Services Inc · Alameda, CABuilt 1981 · S/N 15285444 N93239Minuteman Aviation Inc · Missoula, MTBuilt 1981 · S/N 15285447 N93251Flaherty Edward T · Scotia, NYBuilt 1981 · S/N 15285448 N93263Xin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 15285451 N93264Wolfe Michael S · Norco, CABuilt 1981 · S/N 15285452 N93271Pauma Holdings LLC · Colorado Springs, COBuilt 1981 · S/N 15285454 N93281Bishop Mike · Rifle, COBuilt 1981 · S/N 15285456 N9328UFlymoore Ventures LLC · Saint George, UTBuilt 1976 · S/N 15078277 N93304Jodkin Jason · Confluence, PABuilt 1981 · S/N 15285464 N9330USt Pierre George III · Palm Bay, FLBuilt 1976 · S/N 15078279 N93339Mcgee David · Monroe, LABuilt 1981 · S/N 15285470 N9333URoe Russell M · Martinez, CABuilt 1976 · S/N 15078282 N93342Metro Technology Centers Aviation Career Campus · Oklahoma City, OKBuilt 1981 · S/N 15285471 N93397Jet & Rotor Aviation LLC · Sacramento, CABuilt 1981 · S/N 15285479 N933AZN933az LLC · Miami, FLBuilt 1980 · S/N 15284626 N933SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280526 N93407Board Of Trustees DBA · Murphysboro, ILFirst renewal noticeBuilt 1981 · S/N 15285481 N9340UJohnson Cory D · Rugby, NDBuilt 1976 · S/N 15078289 N93434Silver Express Co DBA · Miami, FLBuilt 1982 · S/N 15285486 N9343ULazor Ronald E · Middlefield, CTBuilt 1976 · S/N 15078292 N93444Sullivan Wayne · Rockport, TXS/N 15285491 N9344UNewman Thomas E · Saint Ignatius, MTBuilt 1976 · S/N 15078293 N93454Marsh John E · Washington, DCBuilt 1982 · S/N 15285494 N93468Bestway Transport LLC · Raymond, NES/N 15285496 N9347UAirgo Inc · Centralia, ILBuilt 1976 · S/N 15078296 N93488Rawareo LLC · Warsaw, MOBuilt 1982 · S/N 15285501 N9351UHolt James D · Greensboro, NCBuilt 1976 · S/N 15078300 N93526Delta State University · Cleveland, MSBuilt 1982 · S/N 15285507 N93529Richmor Aviation Inc · Hudson, NYBuilt 1982 · S/N 15285510 N93550Flight School Of Gwinnett Inc · Lawrenceville, GABuilt 1982 · S/N 15285513 N9357UBaldwin James S · Sylvania, OHBuilt 1976 · S/N 15078306 N93585Sipher William M · Baker, FLBuilt 1982 · S/N 15285521 N9358USaddedine Nouredine · Frisco, TXBuilt 1976 · S/N 15078307 N93590G & M Aircraft Inc · Wheat Ridge, COS/N 15285524 N935CBCalifornia Baptist University · Riverside, CABuilt 1971 · S/N 15073101 N9360UVeenker Frank C · Tygh Valley, ORBuilt 1976 · S/N 15078309 N93621Sunrise Aviation · Ormond Beach, FLBuilt 1982 · S/N 15285527 N9365MFiglia Emanuele · Lewes, DEBuilt 1972 · S/N 15073211 N93689Board Of Trustees DBA · Murphysboro, ILBuilt 1982 · S/N 15285535 N93706Drake Charles R · Claremore, OKBuilt 1982 · S/N 15285539 N93730Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1982 · S/N 15285543 N9374UWest Harold · Ozark, ALBuilt 1976 · S/N 15078323 N9377UDepue Amanda N · Wasilla, AKBuilt 1976 · S/N 15078326 N9378ULrh Equipment LLC · Pendleton, ORBuilt 1976 · S/N 15078327 N9380UForsberg Johnny L · Meridian, IDBuilt 1976 · S/N 15078329 N93831Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 15285557 N9383UEmmons Russell S · Waterbury, CTS/N 15078332 N9386UOdrobina Frank A · North Canton, OHBuilt 1976 · S/N 15078335 N9389UCorrigan Michael D · Hondo, TXBuilt 1976 · S/N 15078337

Back to AD 2009-10-09 R2