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.

N6444SKiser Douglas D · Schererville, INBuilt 1967 · S/N 15067244 N6445FWalk Mason · Maryville, MOBuilt 1966 · S/N 15063045 N6446GHill Jonathan T · Taylorsville, KYS/N 15071946 N6447GVan Holten Robert W · Flemington, NJBuilt 1970 · S/N 15071947 N6448GBradley Gilbert K · Sun Prairie, WIBuilt 1970 · S/N 15071948 N6448MTarrant County College · Fort Worth, TXBuilt 1980 · S/N 15284732 N6449GAlbania Emad R · Huntingtown, MDBuilt 1970 · S/N 15071949 N6452FRobinson Bruce · Salinas, CABuilt 1966 · S/N 15063052 N6453GBegley Scott R · Fairbanks, AKBuilt 1970 · S/N 15071953 N6454KFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1975 · S/N 15077711 N6454MStrickland Deirdre N · Atlanta, GABuilt 1980 · S/N 15284736 N6454SLorance Glenn E · Iola, TXBuilt 1967 · S/N 15067254 N6455KFlying Gators Inc · Overland Park, KSBuilt 1975 · S/N 15077712 N6456FAmb Parnell G · Portland, NDBuilt 1966 · S/N 15063056 N6456PQuad City Area Flying Eagles · Milan, ILBuilt 1981 · S/N 15285016 N6456SBecker Richard Keith · Fraser, MIBuilt 1967 · S/N 15067256 N6457FPepper Christopher W · Memphis, TXBuilt 1966 · S/N 15063057 N6457GN19752 LLC · Toledo, WAS/N 15071957 N6457KWysong Henry D III · Kent, WABuilt 1975 · S/N 15077714 N6458FLejcar Matthew J · Mesa, AZBuilt 1966 · S/N 15063058 N6458LCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284400 N6460FThorton Rod W · Barrington, RIBuilt 1966 · S/N 15063060 N6460LRichmor Aviation Inc · Scotia, NYBuilt 1980 · S/N 15284401 N6460MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284742 N6461GDrewry James D · Scottsboro, ALS/N 15071961 N6462SRoss Mitchell B · Ledyard, CTBuilt 1967 · S/N 15067262 N6463QLyon Aviation Inc · Pittsfield, MABuilt 1981 · S/N 15285255 N6465FBurris Donald E · Lawton, OKS/N 15063065 N6466FGee Ryan S · Luverne, MNBuilt 1966 · S/N 15063066 N6467LHoc Services Inc · Homer, AKS/N 15284405 N6467SFenton Harry L · Rhome, TXBuilt 1967 · S/N 15067267 N6468SMorse Timothy W · Erie, COBuilt 1967 · S/N 15067268 N6469BHale Debra A · Chugiak, AKBuilt 1979 · S/N 15283938 N6469GMaxwell Daniel · Albuquerque, NMBuilt 1970 · S/N 15071969 N6469KPolley Val D · Tucson, AZBuilt 1975 · S/N 15077717 N6469MGeneral Aviation Support Corp · Rosamond, CAS/N 15284744 N6469PSunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15285019 N6469SWeber Worldwide LLC · Cedar Rapids, IABuilt 1967 · S/N 15067269 N6470FMatuska James H · Deary, IDBuilt 1966 · S/N 15063070 N6471MLane Community College · Eugene, ORS/N 15284745 N6473SUlman Gary T Trustee · Mountain Iron, MNBuilt 1967 · S/N 15067273 N6474FDodd Michelle J · Riverton, KSBuilt 1966 · S/N 15063074 N6474KDavis Thomas Aviation Group LLC · Saint Martinville, LABuilt 1975 · S/N 15077718 N6475QFlying Particles Inc · Livermore, CABuilt 1981 · S/N 15285259 N6476FKnowles Brian Thomas · Windsor, NCBuilt 1966 · S/N 15063076 N6477SJuhl Aviation LLC · Luverne, MNS/N 15067277 N6478PHellix LLC · Charlotte, NCBuilt 1981 · S/N 15285025 N6479GGibbons Asher · Mobile, ALBuilt 1970 · S/N 15071979 N6479KHall Charles R · Greenbrier, ARBuilt 1975 · S/N 15077722 N6480FHaithcock Stephen · Oxnard, CABuilt 1966 · S/N 15063080

Back to AD 2009-10-09 R2