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.

N67842Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1978 · S/N 15282051 N67844Patel Pragnesh · Cerritos, CABuilt 1978 · S/N 15282053 N67847Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282056 N67852Sunrise Aviation Inc · Ormond Beach, FLBuilt 1981 · S/N 15285312 N67856Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282061 N67859Guerra Gerald T · Sandusky, OHBuilt 1978 · S/N 15282063 N6785SSchmidt Gary C · Sunrise Beach, MOBuilt 1967 · S/N 15067585 N67864Amoth Travis M · Princeton, CABuilt 1978 · S/N 15282068 N67865Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1978 · S/N 15282069 N6786FBeitz Norman Roy · Quitman, TXS/N 15063386 N67888Flight Directors LLC · Fifield, WIBuilt 1978 · S/N 15282077 N678KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1978 · S/N 15281673 N67904Mirza Wajahat · College Station, TXBuilt 1978 · S/N 15282089 N6790GMartin Christopher G · Monessen, PABuilt 1970 · S/N 15072290 N6790SHildreth Jon R · Spencer, WVBuilt 1967 · S/N 15067590 N67920Thompson William G · Mattawa, WABuilt 1978 · S/N 15282099 N67923Kaluahine Fredstan K · Lihue, HIS/N 15282101 N67924N67924 LLC · Somers, CTBuilt 1978 · S/N 15282102 N6792FPatton Aviation LLC · Billings, MTBuilt 1966 · S/N 15063392 N6792SJohnston Robert G · Rose Hill, KSBuilt 1967 · S/N 15067592 N67930Colonial Air Inc · New Bedford, MABuilt 1978 · S/N 15282106 N6793FOgden John T · Meridian, IDBuilt 1966 · S/N 15063393 N6793GExecutive Flight Institute LLC · Murrieta, CABuilt 1970 · S/N 15072293 N6794GLawson Kurt J · Melbourne, FLBuilt 1970 · S/N 15072294 N67958Stone Wall Acres · Antigo, WIBuilt 1978 · S/N 15282115 N67967Moore Charles E · Gibsonville, NCBuilt 1978 · S/N 15282120 N6796GLyon Scott T · Wellsville, KSBuilt 1970 · S/N 15072296 N6796SRegistration Pending · Lawrence, KSRegistration pendingS/N 15067596 N67973Wings Over Texas Holding LLC · Denton, TXBuilt 1978 · S/N 15282121 N6797FGriswold M Dallas · Cordele, GABuilt 1966 · S/N 15063397 N6798GCowan Ronnie C · Glasgow, KYS/N 15072298 N67991Rainier Flight Service LLC · Renton, WABuilt 1978 · S/N 15282124 N67993Johnson Joshua S · Lake Jackson, TXBuilt 1978 · S/N 15282126 N67995New Horizon Aviation Inc · Warwick, RIBuilt 1978 · S/N 15282128 N6799GWetzler Brian · Bainbridge Island, WABuilt 1970 · S/N 15072299 N6799SAdr Aircraft Service Inc · Burbank, CABuilt 1967 · S/N 15067599 N67ABScaglia Bennett P · Port Orange, FLBuilt 1975 · S/N A1500599 N67GRQuinlan Sherman L · Georgetown, TXBuilt 1966 · S/N 15064854 N67WJBusiness As Usual LLC · Spartanburg, SCBuilt 1973 · S/N 15074915 N6801GDelta Ridge Farms LLC · Oak Grove, LAS/N 15072301 N6802FMccall Freddie W Jr · Brewton, ALBuilt 1966 · S/N 15063402 N6802GFry John W · Vinita, OKBuilt 1970 · S/N 15072302 N6803FBenson George R · Woodlake, CABuilt 1966 · S/N 15063403 N6805FGoodner Brian C · Brookston, INBuilt 1966 · S/N 15063405 N6806FWeakland Christopher · Halifax, VABuilt 1966 · S/N 15063406 N6806GHigley Paul D · Redding, CABuilt 1970 · S/N 15072306 N6807GOriginal Design Ministries DBA · Eatonville, WABuilt 1970 · S/N 15072307 N6808GJewell Daniel J · Texarkana, ARS/N 15072308 N6809FCarlson Christian A L · Orange City, FLBuilt 1966 · S/N 15063409 N6810FAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 15063410

Back to AD 2009-10-09 R2