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.

N964MSMount San Antonio College · Walnut, CAS/N 15079165 N965AAWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282465 N968MSMount San Antonio College Associated · Walnut, CABuilt 1977 · S/N 15281080 N970SETraining Planes LLC · Tampa, FLBuilt 1979 · S/N 15283609 N971AAHobgood David · Bartow, FLBuilt 1966 · S/N 15065572 N971FMFreeway Airport Inc · Mitchellville, MDBuilt 1977 · S/N 15281185 N972MAAir Repair Inc · Easton, MDBuilt 1967 · S/N 15067551 N9733ACloud Dancer Aviation Inc · Deland, FLBuilt 1978 · S/N 15281329 N9785QStory Allen D · Arlington, TXBuilt 1975 · S/N 15076346 N9795VWilliams Bob L · Udall, KSS/N A1500565 N9800JButts James Allen · Gainesville, GABuilt 1975 · S/N A1500609 N9804JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1975 · S/N A1500613 N9809JRies Roger W · Franklin, INS/N A1500618 N980NOneill Aviation LLC · Lake Wales, FLS/N A1520814 N9810JBradley Eric Leon · Anthony, NMBuilt 1976 · S/N A1500619 N9811JJones Mark D · Corsicana, TXBuilt 1975 · S/N A1500620 N9817JDonahue Patrick J · Carriere, MSBuilt 1975 · S/N A1500626 N9819JFranco Louise A · El Cerrito, CABuilt 1975 · S/N A1500628 N9820JBenair LLC · Bonita Springs, FLBuilt 1975 · S/N A1500629 N9822JSiskiyou Pacific Inc · Central Point, ORBuilt 1975 · S/N A1500631 N9828JIcarus Copters LLC · Lancaster, CABuilt 1975 · S/N A1500637 N9830JJohnsen Christian · Big Bear Lake, CAS/N A1500639 N9831JHaddix Stanley D · Hagerhill, KYBuilt 1975 · S/N A1500640 N9832JWolfe William Keith · Greenbrier, ARBuilt 1975 · S/N A1500641 N9835JCrooks Curtis L · Truckee, CABuilt 1975 · S/N A1500644 N9839JDarling Dudley W · Northborough, MABuilt 1975 · S/N A1500648 N9840JBean James P · Tulsa, OKBuilt 1975 · S/N A1500649 N9851JPlanepower LLC · Meridian, MSBuilt 1976 · S/N A1500660 N9852JG & M Associates LLC · Quitman, GABuilt 1976 · S/N A1500661 N9854JAdams James P · Wilbraham, MAS/N A1500663 N9857JReiss Alan T · Puyallup, WABuilt 1976 · S/N A1500666 N9859JNghiem Daniel · Westminster, CAS/N A1500668 N985KKHutto Azel J III · Lexington, SCBuilt 1968 · S/N 15068908 N9864JCottrell James · Mililani, HIBuilt 1976 · S/N A1500673 N9865JNine Winds Inc · Wilmington, DEBuilt 1976 · S/N A1500674 N98680Fischer Alfred M DBA · Genoa City, WIS/N 15069125 N9873JRichards Bradley R · Lake Oswego, ORBuilt 1976 · S/N A1500682 N9875JShaw Aviation LLC · Solomon, KSBuilt 1976 · S/N A1500684 N9879JMccormack Robert · Sacramento, CAS/N A1500688 N9882JS&L Aviation LLC · Ashland, OHBuilt 1976 · S/N A1500691 N9884JDubberly David E · St Simons Island, GABuilt 1976 · S/N A1500693 N9890JOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1976 · S/N A1500699 N9894JKosko Stanley G · Seattle, WABuilt 1976 · S/N A1500703 N9896JVande Berg David M · Sioux Center, IABuilt 1976 · S/N A1500705 N98BVUSA Air LLC · Ruskin, FLBuilt 1974 · S/N 15075695 N98SSSoutheastern Oklahoma State University · Durant, OKBuilt 1977 · S/N 15079353 N9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeS/N A1500456 N9906GNielson Donald L · Independence, ORBuilt 1973 · S/N A1500457 N9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLBuilt 1973 · S/N A1500459 N990CAJundi Adam · North Royalton, OHBuilt 1976 · S/N 15079158

Back to AD 2009-10-09 R2