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.

N48810Training Planes LLC · Tampa, FLBuilt 1977 · S/N 15280976 N48816Feuerlein Maximilian · Tampa, FLBuilt 1977 · S/N 15280979 N48823Silver Express Co DBA · Miami, FLS/N 15280984 N48836Messenger Air Ltd · Madrid, IABuilt 1977 · S/N 15280993 N48842Elon Aviation LLC · Burlington, NCBuilt 1977 · S/N 15280997 N48848Eaglet Flight Operations Lp · Fort Worth, TXBuilt 1978 · S/N 15281000 N48856Neumeister Brian K · Edwardsville, ILBuilt 1977 · S/N 15281005 N48868Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15281013 N48878Kilo Lima Investments LLC · Huntington Beach, CABuilt 1978 · S/N 15281023 N48879Matson Dean R · Spring, TXBuilt 1977 · S/N 15281024 N48883Fly Kful Inc · Fullerton, CABuilt 1977 · S/N 15281026 N48887Fault Line Flyers · Leander, TXBuilt 1977 · S/N 15281030 N4888HRudisel Timothy A · Kewadin, MIBuilt 1979 · S/N 15283999 N4888LAshton Marc J · Petaluma, CABuilt 1980 · S/N 15284239 N48895Mulvania Rodney A · Linn, MOBuilt 1977 · S/N 15281037 N488EKingdom Air Corps · Sutton, AKBuilt 1977 · S/N 15279654 N488EMBishop Patrick M · Reading, MABuilt 1965 · S/N 15062018 N48900Smtm Holdings Inc · Wilmington, DEBuilt 1979 · S/N 15283387 N48918Aero Fliers LLC · Kalispell, MTS/N 15283389 N48924Cobb Susie O · Fayetteville, TNBuilt 1977 · S/N 15281051 N48932Poursartip Nader · Hayward, CABuilt 1977 · S/N 15281056 N48935Chambers Wyatt Allan · Ludlow, MABuilt 1977 · S/N 15281059 N48938International Flying Club Inc · Winfield, ILBuilt 1977 · S/N 15281060 N48941Somboonsap Patanapong · Fort Lauderdale, FLBuilt 1977 · S/N 15281062 N48961Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281074 N48967N48967 LLC · Mount Pleasant, SCBuilt 1977 · S/N 15281079 N48972Pickett Matthew A DBA · Gig Harbor, WABuilt 1978 · S/N 15281083 N4898BPrecon Inc · Anaheim, CABuilt 1979 · S/N 15283697 N48990Hyldburg Aviation · Plymouth, MABuilt 1977 · S/N 15281090 N48FACavu Pilot LLC · Powell, TNBuilt 1965 · S/N 15061895 N48SUGriffith Aviation Inc · Griffith, INBuilt 1981 · S/N 15285186 N49004Oakland Flyers LLC · Oakland, CAS/N 15281094 N49005Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15281095 N4900HNew Horizon Aviation Inc · Warwick, RIBuilt 1980 · S/N 15284009 N4900LJonghan Park · Stanton, CABuilt 1980 · S/N 15284241 N49024B2fh Ltd · Allentown, NJBuilt 1977 · S/N 15281106 N49025Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1977 · S/N 15281107 N49039Welcome Aviation LLC · Hayward, CABuilt 1977 · S/N 15281115 N49043Edwards Pacific Aviation Corp · Dover, DEBuilt 1977 · S/N 15281117 N49055Lima Aviation LLC · Lake Havasu City, AZBuilt 1977 · S/N 15281126 N49060Skylogix Aircraft LLC · La Habra, CABuilt 1979 · S/N 15283410 N49070Ilmberger Stephen Joseph · San Leandro, CABuilt 1977 · S/N 15281133 N49075Mccullough Nancy D · Abilene, TXBuilt 1979 · S/N 15283412 N49078Radar Aviation LLC · Mebane, NCS/N 15281137 N49079Alexander Joseph · Hamilton, INBuilt 1977 · S/N 15281138 N49090Victory Aviation LLC · Winchester, VABuilt 1979 · S/N 15283415 N49094Fleck Richard N Trustee · Camarillo, CABuilt 1979 · S/N 15283416 N49104Jprg Aviation Inc DBA · Orlando, FLS/N 15281151 N4910BCooper Ronald C · Fowlerville, MIBuilt 1979 · S/N 15283702 N49120Aviation Capital Management LLC · San Jose, CABuilt 1979 · S/N 15283425

Back to AD 2009-10-09 R2