AD 95-26-13
Registered aircraft · 21,464
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:95-26-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13')
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:95-26-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-13') 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.
N1412HAsherbranner Charles E · Yucaipa, CAN1416TRegistered aircraftN1417TWood Andrew Calvin · Tallahassee, FLN1418TZucchi Steven · Ephrata, PAN1418XHaskin Kent B · Claverack, NYN1419TBrolan Aviation LLC · Kansas City, MON1419XWhitman Aviation LLC · Morganville, NJN141ANWells Ryan · Holdrege, NEN141AVMavity Michael D · Phoenix, AZN141DDCox Aviation Services LLC · Acworth, GAN141FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN141FQCross Daniel · Windham, NHN141KRScanlon John (Jack) · Palos Heights, ILN141SWCouture Logan · Grand Forks, NDN141TAPray Aviation Inc · Augusta, KSN141WAJohnston James E · Fernandina Beach, FLN1422XDt'S Aviation LLC · Garden City, KSN1423TWaggoner Kevin M · Donnellson, IAN1423XFigueroa Rafael A Jr · Coulterville, CAN1424MFly High LLC · Mobile, ALN1424TFoster Adam J · Houston, TXN1424XLewis Keith W · Clearwater, FLN1425TSkydance Aviation LLC · Norfolk, VAN1425XHowell Joshua · El Cajon, CAN1426THillcrest Of Central Fl LLC · Auburndale, FLN1426XBair Preston W Jr · Coshocton, OHN1427XAlis Aquilae LLC · Opelika, ALN1428JLeedham James E DBA · Mazeppa, MNN1429XRegistered aircraftN142ASGray William Colin · Seattle, WAN142FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN142MHAerospace Trust Management LLC Trustee · Wilmington, DEN142NDSkyblue Aviation Cr Inc · Merritt Island, FLN1430XRuggiero Matthew J · New York, NYN1432TSmith David · Belleville, ILN1433TTilton Dave P · Bradyville, TNN1433XEchota Flyers Inc · Calhoun, GAN1434TStrickland Jason · Gulfport, FLN1435TWaters Nicholas T · Claypool, INN1437HFry Dennis Charles · Anaheim, CAN1437TBenazzi Wahiba · Frisco, TXN1439XDovy Aviation LLC · Houston, TXN143BSMoses Charles · West Friendship, MDN143DWCardinal Aviation LLC · Towson, MDN143EYTriple D Aviation LLC · Merritt Island, FLN143FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLN143JMMa Cedric Sek-Kong · Los Angeles, CAN143TBSmith Timothy T · Turkey, NCN1440UPiper Aircraft Inc · Vero Beach, FLN1442TKeller Mark · Alexandria, KY
Back to AD 95-26-13