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.

N16196Macdonald Kaitlyn A · Dillon, MTBuilt 1972 · S/N 15073539 N1619QAmos Carl R · Chandler, INBuilt 1971 · S/N 15072919 N16202Steward Charles M · Tuttle, OKS/N 15073543 N16206Schultz Aviation Services LLC · Crowley, LABuilt 1972 · S/N 15073544 N16207Martinez Jose Antonio · Orlando, FLBuilt 1972 · S/N 15073545 N16210Simpson Dean H · Limon, COBuilt 1972 · S/N 15073546 N16216Scott Jeffrey A · Camden, TNBuilt 1972 · S/N 15073549 N16221Aero Maintenance Inc · Vancouver, WABuilt 1972 · S/N 15073553 N16222Thumser Douglas Francis · Newcastle, CABuilt 1972 · S/N 15073554 N16223Flyhnz LLC · Oxford, NCS/N 15073555 N16225Tumminaro Michael · Neodesha, KSBuilt 1972 · S/N 15073557 N1622QSchweim Robert J · Ocean City, NJBuilt 1971 · S/N 15072922 N16238Hayes Lance Garett · Opelousas, LABuilt 1972 · S/N 15073564 N1623QHigh Exposure Inc · Wilmington, DES/N 15072923 N16243Como Jerry Wayne · Murfreesboro, TNBuilt 1972 · S/N 15073567 N1625QRegistration Pending · Powell, TNRegistration pendingS/N 15072925 N1627QSky Time LLC · Fort Lauderdale, FLBuilt 1971 · S/N 15072927 N1628QMckeeman Kevin Tee · Abilene, KSBuilt 1971 · S/N 15072928 N162BBAsbery David S · Mt Vernon, ILS/N 15073547 N162FKrueger Luke T · Anchorage, AKS/N 15279773 N162PTAero Fliers LLC · Kalispell, MTBuilt 1981 · S/N 15285278 N1638QBeck Michael C · Farmington, CTBuilt 1971 · S/N 15072938 N163LASimeon Sound LLC · Aguilares, TXBuilt 1967 · S/N 15067645 N1642QTochman Andrew J · Avon Lake, OHBuilt 1971 · S/N 15072942 N1644QBell Norman O · Hurlock, MDBuilt 1971 · S/N 15072944 N1646QOwens Wilbur · Rancho Palos Verde, CAS/N 15072946 N1648QPlane Connection LLC · New Bern, NCBuilt 1971 · S/N 15072948 N1653QDust Devil Weekend Warriors LLC · Ridgecrest, CAS/N 15072953 N1658QHis Kingdom Aviation · Nevada, TXS/N 15072958 N1659QFlying Wings Of Lousiana · Denham Springs, LABuilt 1971 · S/N 15072959 N165FCPocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15064575 N165LADicairano Gerard J · Salisbury, MDBuilt 1967 · S/N 15066156 N1660QDulitz David E · Webster, SDS/N 15072960 N1663QJohnson Steven · Cheyenne, WYBuilt 1971 · S/N 15072963 N1664QWithrow Steven D · Lubbock, TXBuilt 1971 · S/N 15072964 N1666QRegistration Pending · Plymouth, MNRegistration pendingBuilt 1971 · S/N 15072966 N1668QBrunk Hubert J · Lincoln, NEBuilt 1971 · S/N 15072968 N1669QIvy James E · Alba, TXBuilt 1971 · S/N 15072969 N1671QRegistered aircraftBuilt 1971 · S/N 15072971 N1672QHall Donna L · Pulaski, TNS/N 15072972 N16771Tintman Inc · Spokane, WAS/N 15066452 N1679QRegistration Pending · Fulton, MSRegistration pendingBuilt 1971 · S/N 15072979 N1680QHanke Kenneth O · Clio, SCBuilt 1971 · S/N 15072980 N1685QMore Right Rudder LLC · Newnan, GABuilt 1971 · S/N 15072985 N1686QJ3 Jets LLC · Bellaire, TXBuilt 1971 · S/N 15072986 N1689QDolphin Aviation Flyers LLC · Stuart, FLBuilt 1971 · S/N 15072989 N1690QAviation Visions · Fernandina Beach, FLBuilt 1971 · S/N 15072990 N1695QJostad Leo D · Bottineau, NDFirst renewal noticeBuilt 1971 · S/N 15072995 N1698QHudson Gregory K · Deming, NMBuilt 1971 · S/N 15072998 N16EFAnything Aviation LLC · Fort Lauderdale, FLBuilt 1977 · S/N 15280441

Back to AD 2009-10-09 R2