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.

N7088FVander Mey Thomas H · Aitkin, MNBuilt 1966 · S/N 15063688 N708CCOlivier Seth N · Baskin, LABuilt 1966 · S/N 15063262 N7091SMoyer Alan L · Perkasie, PABuilt 1967 · S/N 15067791 N7093FPockrus Pat B · Mineral Wells, TXBuilt 1966 · S/N 15063693 N7094FLarsen Gary A · Honolulu, HIBuilt 1966 · S/N 15063694 N7094SEdwards Thomas · West Richland, WABuilt 1967 · S/N 15067794 N70958Froh Samuel · North Pole, AKS/N 15074631 N7095SSutton Aircraft Salvage LLC · Palmer, AKBuilt 1967 · S/N 15067795 N7096FJanuary Lynn E · Mcpherson, KSFirst renewal noticeBuilt 1966 · S/N 15063696 N7098FBumps Stephen D · Gilead, MEBuilt 1966 · S/N 15063698 N7099FMiles Del R · Blackfoot, IDBuilt 1966 · S/N 15063699 N709LCN709lc LLC · Orange, TXBuilt 1966 · S/N 15063937 N70RQHarbin Elbert W Jr · Dora, ALBuilt 1974 · S/N 15076276 N7101SCuellar Lauren · Eagle River, AKBuilt 1967 · S/N 15067801 N7103SHammerstrand John L · Alpine, CABuilt 1967 · S/N 15067803 N7104SHelm Richard A · Buckeye, AZS/N 15067804 N7107FPoe John B Jr · Port Orange, FLBuilt 1966 · S/N 15063707 N7107GSkyward Aviation LLC · Westborough, MABuilt 1973 · S/N 15074612 N7108SChapman Gary M · Sagle, IDBuilt 1967 · S/N 15067808 N7112FHurst Richard H · Lometa, TXBuilt 1966 · S/N 15063712 N7112SBridges Robert S · Friendswood, TXBuilt 1967 · S/N 15067812 N7114FWernecke Thomas C · Southfield, MIBuilt 1966 · S/N 15063714 N7118GRegistration Pending · Spruce Pine, ALRegistration pendingBuilt 1973 · S/N 15074613 N7118SSanders John B DBA · Knoxville, TNBuilt 1967 · S/N 15067818 N7119FCossette Bradley J · Detroit Lakes, MNBuilt 1966 · S/N 15063719 N711WFSmith Lot P · Grangeville, IDBuilt 1966 · S/N 15063720 N7121FMartin Tricia · Tulsa, OKBuilt 1966 · S/N 15063721 N7125FWerner Angela S · Grand Forks, NDBuilt 1966 · S/N 15063725 N7126SMartin Marty · Summerville, GABuilt 1967 · S/N 15067826 N7127SAbraham Curtis L · Byron, WYBuilt 1967 · S/N 15067827 N7128SHart Brian Jay · San Marcos, TXBuilt 1967 · S/N 15067828 N7129FDavis Clint H · Paola, KSBuilt 1966 · S/N 15063729 N7130FRicker Gary L · Greeneville, TNS/N 15063730 N7130SHansen Christopher H · Durhamville, NYBuilt 1967 · S/N 15067830 N7131FSchoch Brayden · Fort Pierce, FLBuilt 1966 · S/N 15063731 N7133FCarrolls Auto And Aircraft Sales LLC · Muncie, INBuilt 1966 · S/N 15063733 N7134FMejean Kenneth R · Brandon, FLBuilt 1966 · S/N 15063734 N7135FMiller Joseph A · Amissville, VABuilt 1966 · S/N 15063735 N7136GFairchild Natalie J · Drummond Island, MIS/N 15074614 N7136SGonzalez Alec · Homestead, FLBuilt 1967 · S/N 15067836 N7138GWerenko Zandra · Cape Canaveral, FLBuilt 1973 · S/N 15074616 N7138SDeaton Craig · West Alexandria, OHBuilt 1967 · S/N 15067838 N7140BEstep James B · Chillicothe, OHBuilt 1977 · S/N A1520740 N7140FLogan Gregory A · Chouteau, OKS/N 15063740 N7144SLet There Be Flight LLC · Portage, MIBuilt 1967 · S/N 15067844 N7146FR And R Plane LLC · Lewiston, IDBuilt 1966 · S/N 15063746 N7147FHernandez Jorge L · Luthersville, GABuilt 1966 · S/N 15063747 N7148FHigh Flight Aviation Of Kentucky Inc · Lexington, KYFirst renewal noticeBuilt 1966 · S/N 15063748 N7148SJupiter Flight Service And Investing LLC · Lithonia, GAS/N 15067848 N7149SMcateer Kristy · East Greenwich, RIS/N 15067849

Back to AD 2009-10-09 R2