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.

N7166FRegistration Pending · Kenly, NCRegistration pendingS/N 15063766 N7167FSteinhoff Daniel P · Santa Rosa, CABuilt 1966 · S/N 15063767 N7168SInternational Air Services Inc Trustee · Carson City, NVBuilt 1967 · S/N 15067868 N7172SLovaas Darryl G Trustee · Crescent City, CABuilt 1967 · S/N 15067872 N7174SBelasco Thomas D II · Bridgeport, WVBuilt 1967 · S/N 15067874 N7175FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063775 N7177SGambell Jesse D · Mulino, ORFirst renewal noticeS/N 15067877 N7178SMcclain Matthew S · Yelm, WABuilt 1967 · S/N 15067878 N7181FCarter Mark A · Carpinteria, CABuilt 1966 · S/N 15063781 N7182SHoward William M · Greensburg, PABuilt 1967 · S/N 15067882 N7183FN7183f LLC · Spanish Fork, UTBuilt 1966 · S/N 15063783 N7184FYoke Aviation LLC · Bowling Green, KYBuilt 1966 · S/N 15063784 N7184SCade Steven V · Lopez, WABuilt 1967 · S/N 15067884 N7186SEagle Equity Inc · Valparaiso, INBuilt 1967 · S/N 15067886 N7187CWoldt Wayne E · Raymond, NEBuilt 1973 · S/N 681 N7187FHoranzy Paul S · N Grosvenordl, CTBuilt 1966 · S/N 15063787 N7188FCopeland Lance Andrew · Jacksonville, ARBuilt 1966 · S/N 15063788 N7189FTello Ricardo · Mission, TXBuilt 1966 · S/N 15063789 N7191GHis Grace LLC · San Angelo, TXBuilt 1973 · S/N 15074621 N7194Ajayi Samuel O · Fredericksburg, VAS/N 15063922 N7195FAustin Richard K · Ludington, MIBuilt 1966 · S/N 15063795 N7196FStarr Benjamin M · Somerset, OHBuilt 1966 · S/N 15063796 N7196SSale Reported · Taylorsville, MSSale reportedS/N 15067896 N7198FCessna Flyers LLC · Bountiful, UTBuilt 1966 · S/N 15063798 N7199FSale Reported · Pikeville, TNSale reportedBuilt 1966 · S/N 15063799 N71CPKitty Hawk Flight Training And Tours LLC · Nags Head, NCBuilt 1972 · S/N 15073229 N7204SAerolab LLC · Hartwell, GAS/N 15067904 N7205SRegistration Pending · Dillingham, AKRegistration pendingBuilt 1967 · S/N 15067905 N7206GKane Gabriel · Yucaipa, CABuilt 1973 · S/N 15074622 N7207SRademacher Kenneth J · Cleveland, TXBuilt 1967 · S/N 15067907 N7210SAccelerated Aviation Instruction LLC · Owatonna, MNS/N 15067910 N7215SHitt Bruce A · North Augusta, SCBuilt 1967 · S/N 15067915 N7219STulsa Flight Training LLC · Bixby, OKBuilt 1967 · S/N 15067919 N721CWFischer Alfred M DBA · Genoa City, WIS/N 15067112 N7223GLaze Daniel · Carson City, MIBuilt 1973 · S/N 15074624 N7223SSong David D · Ashland, CABuilt 1967 · S/N 15067923 N7225SAero States Aviation LLC · Owasso, OKBuilt 1967 · S/N 15067925 N7226SN46132 Leasing LLC · Kalispell, MTBuilt 1967 · S/N 15067926 N7228SMendoza William S · Antioch, CABuilt 1967 · S/N 15067928 N722LAllen Steven C · Crittenden, KYBuilt 1976 · S/N 15078489 N7233SHeidelberg Haley · Huntington, TXBuilt 1967 · S/N 15067933 N7236SJanvrin Jerry M · Buffalo, SDBuilt 1967 · S/N 15067936 N7237SMetcalf Rodney K · Jonesborough, TNS/N 15067937 N7238SExecutive Flight Institute LLC · Murrieta, CABuilt 1967 · S/N 15067938 N723CMOmbra Aria LLC · Dover, DEBuilt 1978 · S/N 15282823 N723THSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 15281348 N7243SEggers Matthew O · Keller, TXBuilt 1973 · S/N 15075277 N7245SHansen Abree G · Reno, NVBuilt 1967 · S/N 15067945 N7246SDenton Christopher G · Youngsville, NCS/N 15067946 N7247SEpperly Scott E · Creswell, ORS/N 15067947

Back to AD 2009-10-09 R2