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.

N68806G&M Aircraft Inc · Wheat Ridge, COS/N 15282383 N68808Mrb Aviation Inc · Lexington, SCBuilt 1978 · S/N 15282384 N68810Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15282385 N68812Avcorp Holdings Inc · Jackson, MIBuilt 1981 · S/N 15285339 N68813Vogt Jeffrey D · Pleasant Grove, CAS/N 15282388 N68814Spooner Wade G · Donalsonville, GABuilt 1978 · S/N 15282389 N68815Skippy Aviation LLC · Bridgeport, PAS/N 15282390 N68816Mirkovic Alex · Friendswood, TXBuilt 1978 · S/N 15282391 N6882FHernandez Kevin F · Redmond, ORBuilt 1966 · S/N 15063482 N6883GSchroeder David C · Norfolk, NEBuilt 1970 · S/N 15072383 N6887GMassuet Nancy O · Sunrise, FLBuilt 1970 · S/N 15072387 N6889GKozlowski James · Zeeland, MIBuilt 1970 · S/N 15072389 N688CMIcan Solutions LLC · Fargo, NDS/N 15282421 N6891FN6891f LLC · Woodruff, SCBuilt 1966 · S/N 15063491 N68920Richmor Aviation Inc · Hudson, NYBuilt 1978 · S/N 15282403 N68926Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282405 N6892FDent Kelly J · Locust Grove, GABuilt 1966 · S/N 15063492 N6892GDetroit Public Schools Community District · Detroit, MIS/N 15072392 N68934Bapes Debra L · Powell, OHS/N 15285341 N68938Wingspan 152 LLC · Valparaiso, INBuilt 1978 · S/N 15282408 N6893GHuesgen Paul M · Villa Ridge, MOBuilt 1970 · S/N 15072393 N6894FSudduth Robert J · Huachuca City, AZBuilt 1966 · S/N 15063494 N68954Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282414 N68956Spartan Education LLC · Tulsa, OKFirst renewal noticeBuilt 1978 · S/N 15282415 N6895FFaber Elgin J · Havre, MTBuilt 1966 · S/N 15063495 N68961Shouling & Philip Enterprise · Lancaster, CABuilt 1978 · S/N 15282416 N68963University Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1978 · S/N 15282417 N6896FLandmesser Avis C · Troy, MIBuilt 1966 · S/N 15063496 N6897GLewis Derek P · Hurricane, UTBuilt 1970 · S/N 15072397 N68ACSchgallis Richard J · Gainesville, VABuilt 1977 · S/N 15280781 N68FTFat Tire Aviation LLC · New Bern, NCBuilt 1968 · S/N 15068730 N68PGNewsom Kevin J · Bloomington, INBuilt 1968 · S/N 15070027 N68WMHoward Group LLC · Bunnlevel, NCBuilt 1973 · S/N 15074396 N69009Jwa Flight School LLC · Bolingbrook, ILBuilt 1978 · S/N 15282429 N6900FIngle Glenn A · Ypsilanti, MIBuilt 1966 · S/N 15063500 N69011Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282431 N69012Chapel Hill Flying Club Incdba · Sanford, NCBuilt 1978 · S/N 15282432 N69016Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282435 N69019Lange Walter · Plymouth, MABuilt 1978 · S/N 15282438 N69023Gilbert Jeffrey R · Dahlonega, GABuilt 1978 · S/N 15282441 N69031Lewis Garry L · Livingston, LABuilt 1978 · S/N 15282448 N69036Long Robert D · Kinston, NCBuilt 1978 · S/N 15282451 N6903GShipe Jacqueline M · Louisville, TNBuilt 1970 · S/N 15072403 N6903SSchewe William · Greenville, ILS/N 15067603 N69042Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282455 N69043Davidson Craig H · Heber City, UTBuilt 1978 · S/N 15282456 N69045Eburg Aero LLC · Ellensburg, WABuilt 1978 · S/N 15282457 N69047Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282459 N6904SKoller Rex E · Athens, ALS/N 15067604 N69053Aerofeather Aviation Inc · Suffolk, VABuilt 1978 · S/N 15282463

Back to AD 2009-10-09 R2