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.

N7661USweitzer Cameron D · Warrensburg, MOBuilt 1976 · S/N 15077787 N7662UMcintyre James C · Bethlehem, PABuilt 1976 · S/N 15077788 N7665UGazca Aaron Armando · Burgaw, NCS/N 15077791 N7668UMarchbanks William W · Hillsboro, ORBuilt 1976 · S/N 15077794 N7670UMatthews Christopher T · Gardnerville, NVS/N 15077796 N7674UBischoff Daniel C · Camano Island, WAS/N 15077800 N7675GHalopoff Guy · Oroville, CABuilt 1973 · S/N 15074713 N7675UWaite Trevor K · South Ogden, UTBuilt 1976 · S/N 15077801 N7676URhine Steven L · Vancouver, WABuilt 1976 · S/N 15077802 N7677UOrser Shana J · Kissimmee, FLBuilt 1976 · S/N 15077803 N7679UDebenedetto John · Northwood, NHBuilt 1976 · S/N 15077805 N767RWWhitt Robert L · Carolina Beach, NCBuilt 1977 · S/N 15079378 N7682UTech Flight Corp · South Hamilton, MAS/N 15077808 N7690GScott Kyle J · Fort Morgan, COBuilt 1973 · S/N 15074716 N7692UDaso Manuel Sebastian · Spring Hill, FLBuilt 1976 · S/N 15077818 N7693UPerkins Robert A · New Richmond, WIS/N 15077819 N7694UDanfelt Eric A · Bend, ORBuilt 1976 · S/N 15077820 N7697UFox Norman A · Maryville, TNBuilt 1976 · S/N 15077823 N7698ULudwig Edwin E · Stephens City, VAS/N 15077824 N769NERegistration Pending · Pottstown, PARegistration pendingBuilt 1977 · S/N 15280893 N76HVScholz Francis M · Atchison, KSBuilt 1976 · S/N 15078633 N76STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1975 · S/N 15077396 N76YSEstrada Ernesto Alejandro · Yuma, AZBuilt 1965 · S/N 15062483 N7700FClairy Scott M · Justin, TXBuilt 1966 · S/N 15063800 N7703FGonzales Donald M · Columbia Station, OHS/N 15063803 N7704UAllen Philip · Portland, ORBuilt 1976 · S/N 15077826 N7705FEisel Joseph D · Dexter, ORBuilt 1966 · S/N 15063805 N7709FChiang Yucheng · Glenview, ILBuilt 1966 · S/N 15063809 N770NAOrganization Of Black Aerospace Professionals Inc · Westchester, ILBuilt 1975 · S/N 15077280 N770SPHa Emily J · Fort Worth, TXBuilt 1970 · S/N 15071805 N7711FMcclain Eugene L · Maryville, TNBuilt 1966 · S/N 15063811 N7714FRegistration Pending · Oxford, MIRegistration pendingS/N 15063814 N7718FAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1966 · S/N 15063818 N7723FSchlueter Rodney E · Kansas City, MOBuilt 1966 · S/N 15063823 N7725FToney Michael · Saint Peters, MOBuilt 1966 · S/N 15063825 N7726FWargacki Darrin W · Hamilton, OHBuilt 1966 · S/N 15063826 N7729FCardenas Enrique · Brownsville, TXBuilt 1966 · S/N 15063829 N772ZZCirri Joseph A · Deming, NMBuilt 1966 · S/N 15064240 N7730FBmg Aviation Leasing LLC · Bloomington, INBuilt 1966 · S/N 15063830 N7730GSellet Jack A · Winter Haven, FLBuilt 1973 · S/N 15074719 N7731FN7731f LLC · Portage, MIBuilt 1966 · S/N 15063831 N7734FJackson Kimberly F · Wichita Falls, TXBuilt 1966 · S/N 15063834 N7735GShaver John M · Shelby, NCBuilt 1973 · S/N 15074722 N7737FChapman John · San Antonio, TXBuilt 1966 · S/N 15063837 N773SBQuinn Vita Lyn · Palatka, FLBuilt 1969 · S/N 15070665 N773WSPerez Valentino · Sinajana, GUBuilt 1969 · S/N A1500058 N7741FHatch Donna L · Ballston Spa, NYBuilt 1966 · S/N 15063841 N7742FKovac Kenneth K · Mer Rouge, LABuilt 1966 · S/N 15063842 N7744FThoren Patrick · Tenino, WABuilt 1966 · S/N 15063844 N7748GSchilling Erik D · Cumming, GABuilt 1973 · S/N 15074724

Back to AD 2009-10-09 R2