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.

N6975G61hv LLC · Shady Shores, TXBuilt 1970 · S/N 15072475 N6976FCalder Mark A · Midlothian, TXBuilt 1966 · S/N 15063576 N6976SMancine Timothy J · Turner, MEBuilt 1967 · S/N 15067676 N6977FRice Dennis L · Crawfordsville, INBuilt 1966 · S/N 15063577 N6978GSaia Mark · Oak Harbor, WAS/N 15072478 N6979GWestall Ken L · Santa Maria, CABuilt 1970 · S/N 15072479 N6980FEnvii Aviation LLC · Monroe, WAS/N 15063580 N6980GSamudio Lazaro III · Wildomar, CABuilt 1970 · S/N 15072480 N6981SSalerno Gina · Cape Coral, FLBuilt 1967 · S/N 15067681 N6982GBedford Cutter G · Bremerton, WAS/N 15072482 N6983GGoemmel Steven J · Airway Heights, WABuilt 1971 · S/N 15072483 N6984GCoffel Alexander · Meridian, IDS/N 15072484 N6985GBustamante Wilton F · Whitsett, NCBuilt 1971 · S/N 15072485 N6986SKass Deborah J · Chandler, AZBuilt 1967 · S/N 15067686 N6987FGacesa Samuel M · Belton, TXBuilt 1966 · S/N 15063587 N6987SHubbard Broadcasting Inc · Saint Paul, MNBuilt 1967 · S/N 15067687 N6988FPaulson Allerton · Anoka, MNBuilt 1966 · S/N 15063588 N6990FWohlers Paul A · Calimesa, CABuilt 1966 · S/N 15063590 N6991FMeyer George D · Paradise, CAS/N 15063591 N6991GMid South Aircraft Sales Inc · Glencoe, ALBuilt 1971 · S/N 15072491 N6992FJenkins Seth A · Charlotte, NCBuilt 1966 · S/N 15063592 N6992GMosch Edward C · Indialantic, FLBuilt 1971 · S/N 15072492 N6993FBordens Jacob R · Chatham, NJBuilt 1966 · S/N 15063593 N6993VRegistration Pending · Harvey, NDRegistration pendingS/N 15077956 N6994FHerring Jason D · Wasilla, AKS/N 15063594 N6995SNaylor Aviation LLC · Scotch Grove, IABuilt 1967 · S/N 15067695 N6997FSmith Roger D · Fayetteville, NCBuilt 1966 · S/N 15063597 N6998GAviation Trust Company LLC Trustee · Oklahoma City, OKS/N 15072498 N6998SFowler John C · Scott Depot, WVBuilt 1967 · S/N 15067698 N6999FHabibi Airlines LLC · San Juan, PRBuilt 1966 · S/N 15063599 N69HGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1967 · S/N 15066045 N69HPHigh Performance Aircraft LLC · El Cajon, CABuilt 1973 · S/N 15074403 N6EKCjh Aviation LLC · New Bern, NCBuilt 1967 · S/N 15066827 N6MTSchwartz Amy A · Chandler, AZBuilt 1966 · S/N 15062848 N6ZBAsh Reed · Atlanta, GABuilt 1974 · S/N 15075784 N7001GWhite Richard L · Pittsburgh, PABuilt 1973 · S/N 15074601 N7002FMcdonald Timothy M · Meredith, NHBuilt 1966 · S/N 15063602 N7005FUS Flight Academy International Inc DBA · Post, TXBuilt 1966 · S/N 15063605 N7006SSpicer Greg · Portage, MIBuilt 1967 · S/N 15067706 N7007SJw Air Ventures LLC · New Smyrna Beach, FLBuilt 1967 · S/N 15067707 N7008SPoe John B · Port Orange, FLS/N 15067708 N7010XCarrolls Auto And Aircraft Sales LLC · Muncie, INS/N 15285079 N7011FGlow Medspa LLC · Spring Hill, TNS/N 15063611 N7016SCreed Stephen L · Hamilton, VABuilt 1967 · S/N 15067716 N7017SGladwin Stephen R · Pflugerville, TXBuilt 1967 · S/N 15067717 N7019FShore Luke S · Thurmond, NCS/N 15063619 N7021SMountainhawk Leasing LLC · Nampa, IDBuilt 1968 · S/N 15067721 N7023GCunningham Kieran G · Newport, RIBuilt 1973 · S/N 15074608 N7027SRed Cessna Aviation LLC · West Valley City, UTS/N 15067727 N7029SWright Flyers LLC · Fayetteville, GABuilt 1967 · S/N 15067729

Back to AD 2009-10-09 R2