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.

N49438Crickmer Charles C · Overton, NVBuilt 1978 · S/N 15281267 N49439Wisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1978 · S/N 15281268 N4943LBonus Kurt · Wind Lake, WIBuilt 1980 · S/N 15284245 N49447Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281274 N49455Above All Aviation Inc · Goleta, CABuilt 1978 · S/N 15281281 N49461Blue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 15281287 N49470Stidsen Carlton A · Tolland, CTS/N 15281293 N49471Aeroquest LLC DBA · Olive Branch, MSBuilt 1978 · S/N 15281294 N494RAAstra Integrated Technologies LLC · Rockledge, FLBuilt 1967 · S/N 15066996 N4950AShaffer Barbara J · Franklin, KYS/N A1520910 N49516Bresson Flying Service Inc · Compton, ILBuilt 1979 · S/N 15283467 N4951A152 University LLC · Blacksburg, VABuilt 1979 · S/N A1520911 N4951BTaylor Randall G · Pottstown, PAFirst renewal noticeBuilt 1979 · S/N 15283719 N4951HUS Flight Academy International Inc DBA · Post, TXBuilt 1979 · S/N 15284044 N49527B&S Aviation LLC · Sylvania, OHBuilt 1979 · S/N 15283469 N4952BC & T Aviation Holdings Inc · Mckinney, TXBuilt 1979 · S/N 15283720 N4953BTfa Holding Corp · Daytona Beach, FLS/N 15283721 N4954HVega Jaime D · Garland, TXS/N 15284045 N49551Wahl Dale H · Watertown, WIBuilt 1979 · S/N 15283474 N49572Karnik Brandon S · Buffalo Lake, MNBuilt 1979 · S/N 15283476 N4957APea-Wayman Flight LLC · Daytona Beach, FLBuilt 1979 · S/N A1520915 N4958ALamonica Patrick H · San Diego, CABuilt 1979 · S/N A1520916 N495RAGabbard Derek L · Paint Lick, KYS/N 15067052 N495ZZach Brian D · Loveland, COBuilt 1975 · S/N 15076595 N4962BUniversity Of Maryland Eastern Shore · Princess Anne, MDBuilt 1979 · S/N 15283726 N4962HKelly William W · Springfield, ORBuilt 1979 · S/N 15284047 N4962LCypret Phillip B · Sacramento, CABuilt 1980 · S/N 15284246 N49649C & T Aviation Holdings Inc · Mckinney, TXBuilt 1979 · S/N 15283488 N4964PGregory Kristen · Vallejo, CABuilt 1981 · S/N 15284862 N49654Herman Brian · Clarksdale, AZBuilt 1979 · S/N 15283491 N4967BUniv Of Illinois Bd Of Trustees · Savoy, ILBuilt 1979 · S/N 15283730 N49681Sunwest Aviation Inc · Santa Ynez, CAFirst renewal noticeBuilt 1979 · S/N 15283495 N4968PDuncan Arnold A · Bozeman, MTBuilt 1981 · S/N 15284863 N49696Stoffer Aviation LLC · Marion, INS/N 15283496 N49710Peshak Blair Keith · Georgetown, TXS/N 15283498 N49740Horizon Aeronautics Inc · Columbia, SCBuilt 1979 · S/N 15283501 N49769Granzow Jared D Trustee · Powell, OHBuilt 1979 · S/N 15283508 N4976PBecher Dustin Michael · Fort Wayne, INS/N 15284868 N49780Farrell David R · Marysville, WABuilt 1978 · S/N 15281314 N49785Wings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15283514 N4978BSpring City Aviation East LLC · Oconomowoc, WIFirst renewal noticeBuilt 1979 · S/N 15283736 N4978LBarr Stephen L · Spicewood, TXBuilt 1980 · S/N 15284247 N49792Sierra Lima Aviation LLC · Riverton, UTS/N 15283517 N49808Holloway James H · Merritt Island, FLBuilt 1979 · S/N 15283519 N49812Bens Motorworks Inc · Fullerton, CAS/N 15281333 N49818Wings 'N' Rotors LLC · Boise, IDBuilt 1978 · S/N 15281338 N49821Flying Vikings Inc · Hayward, CABuilt 1979 · S/N 15283520 N49824Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281342 N49827Angel Aviation Inc · Peoria, AZS/N 15281344 N49837D&L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1978 · S/N 15281351

Back to AD 2009-10-09 R2