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.

N7357FLittle Bird Airways LLC · Hamburg, NYS/N 15066920 N7372GSky Cops LLC · Midland, TXBuilt 1973 · S/N 15074651 N7374ASouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N A1500726 N737KPPhill-Air Inc · Dover, DEBuilt 1968 · S/N 15067475 N737PACape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1976 · S/N 15078021 N7380LAsiatico Ruperto M · Virginia Beach, VABuilt 1978 · S/N A1520799 N7391LAbdulshafi Ahmed Jason · Oxnard, CABuilt 1978 · S/N A1520808 N7392LKnowles Charles M Jr · Chapmanville, WVS/N A1520809 N7395LCatherines Aviation Services LLC · Sewanee, TNBuilt 1978 · S/N A1520812 N7397BAerolina Inc · Hendersonville, NCBuilt 1977 · S/N A1520766 N7398LNelson Gregory J · Newcastle, CABuilt 1978 · S/N A1520815 N7399AWheeler James H · Bryan, OHBuilt 1977 · S/N A1500731 N73JKGolden Jerry W · Ocean Springs, MSRegistration ineffective or invalidBuilt 1966 · S/N 15064948 N73RJRichard Kent A · Sunset, LABuilt 1966 · S/N 15062833 N7407GStarr Ralph H · Port Orange, FLBuilt 1973 · S/N 15074654 N74150Meyer Tabatha M · Fairview, TXBuilt 1973 · S/N 15074538 N7438GMcguinnis Joseph G · Scottsdale, AZBuilt 1973 · S/N 15074655 N743RBBenefield Shelby · Attalla, ALS/N 15072497 N7440GJohnes Charles H · Santa Maria, CABuilt 1973 · S/N 15074656 N7451GPresto William R · Houston, PABuilt 1973 · S/N 15074660 N745FWWalther Frank C · Crawford, COBuilt 1980 · S/N 15283905 N7460GHelping 24 Hours LLC · Goodyear, AZS/N 15077663 N746DGVolkernick Peter A · Rumford, MEBuilt 1966 · S/N 15065758 N7471GKyle Allyn B · Snohomish, WABuilt 1973 · S/N 15074664 N747KYMahany John S · Long Beach, CABuilt 1970 · S/N 15071860 N747ZPAuburn Valley LLC · Farmington, MNBuilt 1977 · S/N 15279476 N7486SGarage Doors Of Greenville LLC · Greenville, MSBuilt 1969 · S/N 15070358 N74ALDavis Tessie · Buckeye, AZBuilt 1974 · S/N 15075510 N74GTKnick Robert J · Eugene, ORBuilt 1969 · S/N 15070302 N74KWWilling Kenneth Allen · Grasston, MNS/N 15063752 N74UAnderson Ray L · Auburn, CAFirst renewal noticeBuilt 1977 · S/N 15079197 N7505GRandall James E · Villa Park, CABuilt 1973 · S/N 15074674 N750PHTobon Alexander J · Daphne, ALS/N 15073040 N7510GBoh Air Corporation · Jenks, OKBuilt 1973 · S/N 15074676 N7515GFrisbee Alice Molnar · Port Charlotte, FLBuilt 1973 · S/N 15074681 N7515UUren Peter J · Redwood Falls, MNS/N 15077732 N7517GDecember 1944 LLC · Las Vegas, NVBuilt 1973 · S/N 15074683 N751DSHigh Exposure Inc · Wilmington, DEBuilt 1965 · S/N 15062266 N7529GRibeiro Marcos F · Okeechobee, FLS/N 15074687 N752MFEpperly David J · New Richmond, WIBuilt 1974 · S/N 15075977 N7533GSiess Tye G · Hot Springs, ARS/N 15074691 N7538UHooper Lawrence S · Melba, IDBuilt 1975 · S/N 15077734 N7539UAirgo Inc · Centralia, ILS/N 15077735 N7553BTri Star Aviation Inc · Nashua, NHBuilt 1977 · S/N A1520767 N7558LBahinting Dan Brian M · Rosamond, CABuilt 1978 · S/N A1520819 N7559UFreeman Jet LLC · Cape Coral, FLBuilt 1975 · S/N 15077736 N7560GGreen Carl S · Crivitz, WIS/N 15074699 N7562USchuebel Douglas R · Cameron, WIBuilt 1978 · S/N 15077738 N7564USabatowich Erik J · Detroit, MIBuilt 1975 · S/N 15077740 N7572UAirfrank Inc · Hackensack, NJBuilt 1975 · S/N 15077741

Back to AD 2009-10-09 R2