AD 2011-26-07
Registered aircraft · 13,298
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
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:2011-26-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-26-07')
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:2011-26-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-26-07') 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.
N1134FScialabba John E · Columbus, OHN1134HFeldhusen Lawrence E · Yankeetown, FLN1135HSale Reported · Fort Smith, ARSale reportedN1136HMusgrove Louis A Jr · Cumming, GAN1137FWisti James G · New Hudson, MIN1138HAgaliotis Paul E · San Martin, CAN1139FGifford Kenneth A · Appleton, WIN1139ZGonet John Charles · Southwick, MAN113DFRegistered aircraftN113VKHaskell Brenton · Georgetown, KYN1140TRegistered aircraftN1141BMiddleton Robert J · Truth Or Consequen, NMN1141HMorris David · Hillsdale, MIN1142FHart James A · Arlington, VAFirst renewal noticeN1142HSimmons Donald E · Clifton Park, NYN1142XAerofeather Aviation Inc · Suffolk, VAN1143FWilson Dan · Saginaw, TXN1143WRiner Mark G · Bartlesville, OKN1146FLarson Larry D · Sargeant, MNN1146MMitchell Kenneth A · Uniontown, PAN1147DWesterhold Wayne E · Cary, NCN1147FParker Robert M · Hurst, TXN1147GIcarus Transport LLC · Charlotte, NCN1147VRegistration Pending · Moore, OKRegistration pendingN1148FReed Roger · Lebanon, KYN1148HReed Charles H · Shelbyville, KYN1149BStefenelli Aviation N Tr Inc Trustee · AtterseeN1149FLemery Aaron D · Chattaroy, WAN1149GShine Flyer LLC · Kalispell, MTN1149HN1149h Inc · Pembroke Pines, FLN1149LAviation Trust Company LLC Trustee · Oklahoma City, OKN1149PWilliams Joseph A · Jacksonville, FLN114BSBravo Sierra LLC · Seattle, WAN114JRN114jr LLC · Canyon Lake, CAN1150UHaskins Kerry H · Tampa, FLN1151UCoconut Telegraph LLC · Missoula, MTN1152HWeiler Coen A · Ashville, OHN1152KVan Hook James W · Sylvania, OHN1152LMcdonald Glenn · Uvalde, TXN1152NDowd Tedd J · Goodyear, AZN1152QHilterbrand Wayne D Jr · Keizer, ORN1152VGolden Eagle Consulting LLC · Williston, NDN1154HLechner Burdette J · Kodiak, AKN1155FDejesus Rodolfo B · Murfreesboro, TNN1156Ind Aerospace LLC · Lumber Bridge, NCN1156GWilliams Michael E · Horseshoe Bay, TXFirst renewal noticeN1156KN1156k 231 LLC · Dearborn Heights, MIN1156MJays Aircraft Maintenance Inc · Costa Mesa, CAN11575Pyle Howard H · Cornelius, ORN1157FKiss George C · Bangor, PA
Back to AD 2011-26-07