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.

N9448UValley View Farming Inc · Halsey, ORFirst renewal noticeS/N 15078396 N94500Training Planes LLC · Tampa, FLBuilt 1983 · S/N 15285692 N94505Riverside Flight Center Inc · Tulsa, OKBuilt 1983 · S/N 15285696 N94513Hampden Aviation Services Inc · Northampton, MABuilt 1983 · S/N 15285702 N9451UPilot Pros Inc · Miami, FLBuilt 1976 · S/N 15078399 N94528Daedalus Flight School Inc · P. FokaiaS/N 15285705 N9452UCurtis Marilyn D · Woodland, CABuilt 1976 · S/N 15078400 N94532Oklahoma State University · Stillwater, OKFirst renewal noticeBuilt 1983 · S/N 15285707 N94553Delta State University · Cleveland, MSBuilt 1983 · S/N 15285718 N9455UUniform Aircraft Holdings LLC · Ransom, ILS/N 15078403 N94569Chester Charter Inc · Chester, CTBuilt 1983 · S/N 15285731 N94570Richmor Aviation Inc · Hudson, NYBuilt 1983 · S/N 15285732 N94573Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1983 · S/N 15285735 N94577Ace Aircraft Leasing Inc · Nazareth, PABuilt 1983 · S/N 15285736 N9457UClemens Jerry W · Parsons, KSBuilt 1976 · S/N 15078405 N94584Sale Reported · West Lafayette, INSale reportedBuilt 1983 · S/N 15285738 N94585Aviation Trade Inc · Castroville, TXBuilt 1983 · S/N 15285739 N94589Haverlock Aircraft LLC · Willoughby, OHBuilt 1983 · S/N 15285740 N945KMSkypros East Kansas City · Grain Valley, MOBuilt 1977 · S/N 15280816 N94609Heavy Metal Air LLC · Farmingdale, NYBuilt 1983 · S/N 15285742 N9460UMarkham Clint D · Vinita, OKBuilt 1976 · S/N 15078408 N94626New Horizons Aviation Inc · Goshen, INS/N 15285747 N9463UMonday Terry A · Greenville, NCBuilt 1976 · S/N 15078411 N94652Maryak Hans F · Somersworth, NHBuilt 1983 · S/N 15285752 N94655Iowa Great Lakes Flyers Inc · Cheyenne, WYBuilt 1983 · S/N 15285753 N94659Pavco Inc · Gig Harbor, WABuilt 1983 · S/N 15285755 N94661Fjiro Aviation N94661 LLC · Vancouver, WAFirst renewal noticeBuilt 1983 · S/N 15285756 N9467UPowell Travis R · Clinton, MOS/N 15078415 N94684Delta State University · Cleveland, MSBuilt 1983 · S/N 15285763 N94688Lyon Aviation Inc · Pittsfield, MABuilt 1983 · S/N 15285765 N9469UBrennecke Matthew L · Tulsa, OKBuilt 1976 · S/N 15078417 N946ACNaples Air Center Inc · Naples, FLBuilt 1985 · S/N 15286018 N946SFSnohomish Flying Service Inc · Snohomish, WABuilt 1978 · S/N 15282353 N94714Wright Aero Inc · Saint Cloud, MNBuilt 1983 · S/N 15285771 N9474UMay Randall T · Maquon, ILBuilt 1976 · S/N 15078422 N9475UGerlach Brett C · American Fork, UTBuilt 1976 · S/N 15078423 N94768Indian River Flying Club Inc · Rockledge, FLBuilt 1983 · S/N 15285782 N9476USantos Enderson Rafael Teixeira Dos · Aledo, TXBuilt 1976 · S/N 15078424 N9477URegistration Pending · Delta Junction, AKRegistration pendingBuilt 1976 · S/N 15078425 N94790Kingsky Flight Academy LLC · Lakeland, FLS/N 15285788 N947SFSnohomish Flying Service Inc · Snohomish, WABuilt 1983 · S/N 15285770 N9480UColeman Stephen A · Wakefield, RIBuilt 1976 · S/N 15078428 N9481UParnell Jr Jerry · Panama City, FLBuilt 1976 · S/N 15078429 N94822Elon Aviation LLC · Burlington, NCBuilt 1983 · S/N 15285795 N9482UClark Josh D · Morehead, KYBuilt 1976 · S/N 15078430 N9487UCallejo Joseph S · Port Saint Lucie, FLBuilt 1976 · S/N 15078435 N9488UGardner Christopher · Addison, TXBuilt 1976 · S/N 15078436 N94891Avcorp Holdings Inc · Jackson, MIBuilt 1983 · S/N 15285806 N9489URodriguez Alonso Jr · Alamo, TXBuilt 1976 · S/N 15078437 N9494GKelly William W · Springfield, ORBuilt 1977 · S/N 15279527

Back to AD 2009-10-09 R2